Re: Very fast select

From: Steven Brangers <steven.brangers_at_altavista.net>
Date: Sat, 10 Feb 2001 10:49:39 +0100
Message-ID: <newscache$cmcj8g$xi9$1@news.freegates.be>

Maybe partitioning does the trick

(did you find a solution already ?
Can you let me know which conclusion works ? Thanks, stevenbrangers_at_freegates.be)

Steven Brangers.

<iustinami_at_my-deja.com> schreef in berichtnieuws 95eu2r$ci2$1_at_nnrp1.deja.com...
> 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 10 2001 - 03:49:39 CST