Index usage for a table

2001-01-30 Thread Browning, Alan
Is there anyway to find out which indexes are being used and which ones are not being used for any given table? Thanks in Advance Alan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browning, Alan INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: Index usage for a table

2001-01-30 Thread Oliver Artelt
On Tuesday 30 January 2001 23:47, [EMAIL PROTECTED] wrote: run a query using explain plan ... and use sql trace oli -Original Message- Alan Sent: Tuesday, January 30, 2001 4:40 PM To: Multiple recipients of list ORACLE-L Is there anyway to find out which indexes are being