Re: Tuning - Indexes and Usage

A bit of a stretch, but if you could put an index in it's own datafile you could measure the Physical and/or logical reads. Not sure though if updates to the index cause any reads that are recorded. You could test this by creating an index that would never be used, add/update/delete rows and then look at the information in the v$filestat and v$datafile views. Then do queries that should read the index and see what happens.

Could Try OEM performance manager and record this information for a duration when queries should cause reads on the index datafile.

"Devdewboy" <devdewboy_at_hotmail.com> wrote in message news:<blGS6.8764$3t5.261151_at_news.pacbell.net>...
> Good Morning,
>
> Is there a script someone can provided me that will query the dynamic views
> for index usages i.e. If an index has ever been utilized (this specifically)
> and other useful info?
>
> Thanks,
>
> dewboy
Received on Wed Jun 06 2001 - 13:44:42 CDT