Re: re creating a primary key on a table makes requests faster?

allen.darrin_at_gmail.com wrote:

> I think when you drop and then add the primary key it causes the data
> in the table to reorginize which is similar to a performance tuning
> change.

Absolutely not. Never. Ever. Period. Exclamation Point. Bold Faced.

> Meaning if you had fragmented data you organize it.

No index build is capable of affecting table data in any manner in Oracle.

In Oracle if you want ordered data you either build an Index Organized Table (IOT) or, in a sense you build a sorted hash cluster. But even with the sorted hash cluster it is the hashes that are sorted ... not the data.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org