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 ????