Re: ** re-insert data in primary key order

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Tue, 11 Oct 2005 09:22:30 -0700 (PDT)
Message-ID: <20051011162230.74897.qmail@web50103.mail.yahoo.com>

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_at_yahoo.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 11 2005 - 11:24:38 CDT