OraFAQ Forum: SQL & PL/SQL » Pre Sorted Table on column other than Primary Key(Very-very urgent)

Home » SQL & PL/SQL » SQL & PL/SQL » Pre Sorted Table on column other than Primary Key(Very-very urgent)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pre Sorted Table on column other than Primary Key(Very-very urgent) [message #20668]

Wed, 12 June 2002 10:44

Piyush Gupta
Messages: 1
Registered: June 2002

Junior Member

Hi,
I am looking to store all the columns and the data of a table sorted on a column other than the primary key so that when i select * from (tabname) order by (colmn_name), i do not have to wait for online sorting of records. Indexes are of not much use, bcoz they come into play when you search from that particular column.
Any way out please let me know

Report message to a moderator

Re: Pre Sorted Table on column other than Primary Key(Very-very urgent) [message #20669 is a reply to message #20668]

Wed, 12 June 2002 11:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

U MAY create a create a view (or another table) with your own sorting requirement.

SQL> create table new_emp as select * from emp order by sal;

Table created.

Report message to a moderator

Previous Topic:	Difference between application procedures and stored procedures
Next Topic:	Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 13:36:24 CDT 2024