Database Index Problem

[Former Member]

Hi

I have create an index with 4 columns. Wow, my select is very fast. But only one day. Next day the index dosn't match. Explain plan sad full table scan - so the statement is very slow. If I anlayze the table - nothing changes, but if I go to the database utility and select the index and klick the button "activate and adjust database" the statment works very fast - but only for one day. Any idea whats wrong.

Thanks Stefan

[Former Member]

Check, you have selected the radio button

Non-unique Index -->Index on all database systems

Regards,

Prakash.