Question toad: Index utilized for xx%

From: ITAPORT06 <mokat67_at_hotmail.com>
Date: Sun, 06 Jul 2003 15:42:29 +0200
Message-ID: <h97ggvc7g61q2jqpovgasbslg8eb1o7b1s@4ax.com>

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 Sun Jul 06 2003 - 08:42:29 CDT