From: iustinami@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Very fast select
Date: Fri, 02 Feb 2001 18:25:42 GMT
Organization: Deja.com
Lines: 22
Message-ID: <95eu2r$ci2$1@nnrp1.deja.com>
NNTP-Posting-Host: 194.102.231.115
X-Article-Creation-Date: Fri Feb 02 18:05:17 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows 98; DigExt)
X-Http-Proxy: 1.1 x61.deja.com:80 (Squid/1.1.22) for client 194.102.231.115


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/