DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Indexes

  1. #1
    Join Date
    Feb 2001
    Posts
    100
    Hi all,

    Is it possible to enable/disable indexes like constraints. I used UNUSABLE option but It gives me an error.

    Thanks in advance

  2. #2
    Join Date
    Mar 2001
    Posts
    45
    LEt me know what is your requirement to do so.
    This will help us to provide a better solution for your problem.
    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  3. #3
    Join Date
    Feb 2001
    Posts
    100
    I want to inhibate the indexes for a short time to do some tests and after enable them. I dont want to drop and then recreate them.

    Thanks

  4. #4
    Join Date
    Mar 2001
    Posts
    45
    As far as I know , you can use the
    FFS hint in you tests (SQL commands) ,

    This will definitely inhibits the usage of indexes.
    No direct command to enable/disable like constraints.

    [ Is it possible to make an index corrupt, so that one the testing parting is over, we can submit
    VALIDATE INDEX command to make it set right]

    Can anybody give a better solution, Pl.
    Thanx
    Ramesh.
    ______________________________
    There is nothing Impossible.
    Even Impossible says
    I M POSSIBLE

  5. #5
    Join Date
    Feb 2001
    Posts
    389
    Suppress them in your queries ./
    USE ALL_ROWS as your optimizer_goal
    + increase db_file_multiblock_read_count.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width