Very fast select

From: <iustinami_at_my-deja.com>
Date: Fri, 02 Feb 2001 18:34:01 GMT
Message-ID: <95euio$d35$1@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 a Oracle 8i running on a K7, 256Mb with 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 idea please help.

Thanks in advance,

Iustin

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 12:34:01 CST