RE: How many times has an index been used?

all execution plans in a BDE database. It then scans through all the exectution plans to determine whether an index is used or not. It doesn't however tell you how many times the index has *actually* been used.. Mark -Original Message- Sent: Friday, May 25, 2001 09:18 To: Multiple

Re: How many times has an index been used?

the exectution plans to determine whether an index is used or not. It doesn't however tell you how many times the index has *actually* been used.. Mark -Original Message- Sent: Friday, May 25, 2001 09:18 To: Multiple recipients of list ORACLE-L There is commercial software

RE: How many times has an index been used?

, Wilkes, Steve wrote: Hi, Does anyone know how to determine how many times an index has been used or if it has been used at all? I have seen previous attempts by taking snapshots of v$sqlarea and then automating an explain plan and extracting the information that way. I would have thought

RE: How many times has an index been used?

in a BDE database. It then scans through all the exectution plans to determine whether an index is used or not. It doesn't however tell you how many times the index has *actually* been used.. Mark -Original Message- Sent: Friday, May 25, 2001 09:18 To: Multiple recipients of list ORACLE-L

Re: How many times has an index been used?

: Hi, Does anyone know how to determine how many times an index has been used or if it has been used at all? I have seen previous attempts by taking snapshots of v$sqlarea and then automating an explain plan and extracting the information that way. I would have thought that there must

Re: How many times has an index been used?

There is commercial software for determining this. www.teleran.com www.pinecone.com Both rather spendy. Jared On Thursday 24 May 2001 06:10, Wilkes, Steve wrote: Hi, Does anyone know how to determine how many times an index has been used or if it has been used at all? I have seen