-
Hi all,
Is it possible to enable/disable indexes like constraints. I used UNUSABLE option but It gives me an error.
Thanks in advance
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|