Primary key index performance

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 - 12:34:23 CST