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

Home -> Community -> Usenet -> c.d.o.server -> Re: Primary Key INDEX

Re: Primary Key INDEX

From: Arthur <arthur_at_stario.com>
Date: 2000/03/01
Message-ID: <6Qjv4.153$zz5.15819@news.pacbell.net>#1/1

Arthur <arthur_at_stario.com> wrote in message news:Q0fv4.116$zz5.12434_at_news.pacbell.net...
> Could anyone tell me were is location of Primary Key 'INDEX' ;
> (on default user tablespace, System Index or IDXS tablespace?)
> Thank you,
> arthur
>
>>When I created INDEX on Primary Key, the performence improoved about 300%.

In explain plan it was not use index ( the TABLE ACCESS FULL ) and after creation on INDEX on Pimary Key ( INDEX FAST FULL SCAN ) why it happend,
Thank you,
Arthur Received on Wed Mar 01 2000 - 00:00:00 CST

Original text of this message

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