Indexes

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.

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.

Suppress them in your queries ./
USE ALL_ROWS as your optimizer_goal
+ increase db_file_multiblock_read_count.