Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Primary key index performance
What is a 10k select statement?
First thing I'd do is run Explain Plan.
Without you posting any useful information about the sizes of your tables, the number of rows, the SQL, etc. it is impossible to give you any kind of an answer.
Daniel Morgan
Hugues Landry wrote:
> Hi everyone,
> I was wondering. Is there a way to alter a primary key index to
> improve its performance ( let's say by boosting the degree ) ?
>
> If not what are the classic performance optimisation that one would
> do in order to make 10k select statement faster ( i mean a LOT faster
> ) :-)
>
> Thanks in advance.
>
> Hugues Landry
>
> PS : i'm using oracle 8i
Received on Fri Feb 01 2002 - 10:44:46 CST