Re: Question about query performance issue

From: Thomas Day <tomdaytwo@xxxxxxxxx>
To: mschmitt@xxxxxxxxxxxx
Date: Thu, 26 Feb 2009 14:19:10 -0500

You might try destroying the statistics on 'MEDIATYPES_PK' and seeing if
Oracle will choose 'MEDIAXREFS_PK' instead.

Or, you might lower the num_rows on 'MEDIAXREFS_PK' to try to make a full
index scan of that index more attractive.

References:
- Question about query performance issue
  - From: Michael Schmitt

Other related posts:

» Question about query performance issue- Michael Schmitt
» Re: Question about query performance issue - Thomas Day