The best way is to use Ops Navigator to run Visual Explain on the SQL
Statement and see what it recommends. You can also turn on debug and get
more detailed messages in the job log. Visual Explain is the best. You
might also check the Index Adviser in Ops Nav to see if it is building any
indexes when you run the SQL statement.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact