Re: index never used

andreas.prusch_at_t-online.de (Andreas) wrote:

>
>monitoring indexes can be done with 9i. If you still want
>to use version 8, you can query the sql-statements from v$sql
>and afterwards let them explained by explain plan command.

That is fine Andreas.. but then how do you convey the results to the unwashed, get them to accept it, get them to write decent SQL, using a proper indexing strategy?

No amount of explain planning or v$ tables can fix "political problems" in the office.

Seriously. What do you do when you have a database where the combined size of the indexes of a table is 20% larger than the actual table itself? What do you when despite all the technical reasoning, justification you throw at it, it is not considered a worthy issue by the developers/consultants or management, 'cause the system is working okay. For now. Never mind the overheads those indexing cause on the daily insert and update transactions on that table. Never mind how much fragmentation problems it cause in the index tablespace. Never mind the impact on physical space requirements on the platform. What do you? Shooting the hostage only worked for Keanu in Speed 1. ;-)

The technicalities of managing a database is the easy part when it comes to DBA duties. It is the rest of the crap that you need to deal with, that is the real problem. And none of how to handle this are in any of these fancy Oracle books and manuals.

--
Billy