Re: Primary Key INDEX

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