Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a second table as sorted on one column of first table?

Re: How to create a second table as sorted on one column of first table?

From: Bob Rhodes <brhodes_at_goodnet.com>
Date: 16 May 1998 23:56:26 GMT
Message-ID: <01bd8125$af939620$c1b762cf@lynn>


A simple statement to force use of an index (causing order by) is

select ... from ... where indexed_column_name > ' '

This has saved me a lot of work!

Lynn

David Shi <dshi_at_magpage.com> wrote in article <6jipt0$m7a$0_at_204.179.92.109>...
> I tried:
>
> create table second as select * from first order by key;
>
> but didn't work. Any help is greatly appreciated!
>
> David
>
Received on Sat May 16 1998 - 18:56:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US