Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help with monstrous query migrated from sql server

Re: Need help with monstrous query migrated from sql server

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2006 08:54:54 -0700
Message-ID: <1145462094.247858.213970@e56g2000cwe.googlegroups.com>


Rule 1 when asking for Performance Tuning help is to always post the Explain Plan for the SQL statement in question.

Did you generate statistics in Oracle for the tables? How? And what is the Oracle editon, version, and platform anyway?

What indexes if any are available on these tables? What are the PK of the tables involved in this query?

Can the data in the jurenhet column of these tables be converted to uppercase only? This may allow a (non-function based) index to be used on these columns. Adding a function based index on these column might also be an option but any such decisions as that should be made after the plan is exaimined, existing indexes considered, etc....

HTH -- Mark D Powell -- Received on Wed Apr 19 2006 - 10:54:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US