Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Primary Key INDEX
From: Arthur <arthur_at_stario.com>
Newsgroups: comp.databases.oracle.server
Sent: Wednesday, March 01, 2000 12:17 PM
Subject: Primary Key INDEX
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 used 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