How to find the SQL that uses an specific index
Hello,
I have started to get deadlock alerts on a database when concurrent sessions are trying to insert data in a table that has a bitmap index.
I monitored the index and It has been marked as used (alter index ... monitoring usage;)
I am not certain about what operations actually will mark the index as used, Is it only Select statements?
The other question is, Is is possible to find the exact SQL statements that use an index?
Thanks in advance,
Daniel
I have started to get deadlock alerts on a database when concurrent sessions are trying to insert data in a table that has a bitmap index.
I monitored the index and It has been marked as used (alter index ... monitoring usage;)
I am not certain about what operations actually will mark the index as used, Is it only Select statements?
The other question is, Is is possible to find the exact SQL statements that use an index?
Thanks in advance,
Daniel
1