Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to create a second table as sorted on one column of first table?
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