Home -> Usenet -> comp.databases.oracle -> Physical sort of a table

Physical sort of a table

From: Vinod Jain <vkj_at_ctt.bellcore.com>
Date: 1995/06/27
Message-ID: <vkj.305.2FF02E9E_at_ctt.bellcore.com>#1/1 






Hi,



I want to store a table physically sorted on certain columns so that I don't 
have to use 'order by' clause in my 'select ' queries. The 'select' query 
which I am trying to tune has joins with 2 more tables.   Does primary key 
index sorts the table (like a clustered index in Sybase) ? 



Thanks,


Vinod
Received on Tue Jun 27 1995 - 00:00:00 CEST












Original text of this message