SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to tell if a table is ordered or un-ordered ?

user517698Oct 23 2006 — edited Nov 17 2006

Hi ,

How can i tell if a table is ordered or un-ordered w/o using the order by or group by ?

i read somewhere that for an ordered table if rows returned < 40% better to use indexes and for unordered tables if its less < 7%

pls advise

tks & rdgs

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2006

Added on Oct 23 2006

64 comments

5,459 views