Re: Question toad: Index utilized for xx%

I unfortunately don't know Toad, but if you happen to be on Oracle 9i, you can "monitor" the indexes' usage ("alter index ... monitoring"). Afterwards, you can see in USER_INDEXES if the indexes were ever used in execution plans. If in Oracle 8i, you might have to rely on using a script (I think ixora has it) to look at the SQL statements currently cached, get their execution plans, and find out from them which indexes are accessed (this is very resource-intensive, careful!). Let me know if you're not clear

Daniel

> When i get into the TOAD- DBA - Server Statistics then I get
> information about the use of indexen. In my case that it was 70%
> I know that (sometimes) a full table scan can be fast then using an
> index but my question is:
>
> Where can collect the tables names for which no index was not used !!
>
> I know that I can retrieve in TOAD - Tools: the statements and the
> explanation if the statement used an index or not but can I read this
> information in one time for all the tables?
> Thanks
Received on Mon Jul 07 2003 - 08:46:42 CDT