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

you might want to ask this question on a website that is dedicated to helping people with database issues and when you ask it there make sure you state the RDBMS you're using.