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

• » Related posts
• » Previous by Date
• » Next by Date
• » This Month's Archive
• » Main Archive Page

• » View list details
• » Manage your subscription