Re: Very fast select

From: John Russell <johnrussell10_at_home.com>
Date: Sat, 03 Feb 2001 22:25:09 GMT
Message-ID: <0v0p7t8gagshmignmjjvrt3i6hgv0lgk8p@4ax.com>

It sounds like what you're looking for is an index-organized table. Here is the relevant information from the 8.1.7 docs:

http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?word=index-organized+table%7Ciot&book=&preference=&vbook=1

John

On Fri, 02 Feb 2001 18:25:42 GMT, iustinami_at_my-deja.com wrote:

>Hi,
>
> I need very fast answers to <order by> selects
>on a table ( max 1-2 seconds ) that must contain
>a varchar field ( the <order by> field ). The
>table has about 300000 rows.
> I've tried indexing, primary key on varchar
>field, but still too slow. The server is Oracle
>8i on a K7, 256Mb running Win2000 ).
> I think I need something like the low-level
>order of rows in database to be exactly the
>varchar field order.
> If you have any ideea please help.
>
>Thanks in advance,
> Iustin Amihaesei
>
>
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Sat Feb 03 2001 - 16:25:09 CST