You can get a query execution plan from Oracle and see exactly which indexes are and are not being used (with the "explain plan" command -- it requires a little setup first).  You can also install statspack (I think this is renamed now?) and get extensive debugging stats from it.

On Jul 14, 2006, at 1:11 AM, Owen McKerrow wrote:

DOH ! **Hits self in the head** Thats one thing I need to do when there DBA gets back from holidays :) We moved the DB from OpenBase to Oracle and we haven't been back an applied indexing yet : )


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to