I am having a table with more than 1000 records, i am not having index
in that, while executing that query it occupies the processor..
I created an index, and then executed that query., Now it is not
getting executed at all... while seeing the top the processor is busy
in WA, that it is waiting for device....
i thought it is because of some process, and tested it again, and again
and found that the processor is busy with this device whenever this
query is executed...
i dropped the index and tried, now the query is executed but it takes...
any idea ????
