Re: ** re-insert data in primary key order
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 11 Oct 2005 09:22:30 -0700 (PDT)
If the PK index is used by majority of the queries, those will benefit.
Yes, Oracle will know about the ordered data from the index clustering factor.
I suggest referring to docs/notes that discuss index clustering factor (google
search
will help your there).
Here is one link I like : http://www.dizwell.com/html/clustering_factor.html
Cheers!
-Kirti
--- A Joshi <ajoshi977@xxxxxxxxx> wrote:
> Hi,
> I would like to know if delete and re-insert of table data in primary key
> order is of
> help. And in what circumstances. Is there a way for Oracle to know or hint it
> that data
> is in primary key order? Any related info? Thanks
>
>
> ---------------------------------
> Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
