Thiko! wrote:
> Hi
>
> I have a table with a unique concatenated index on 2 of its NUMBER
> datatype columns. The table only consists of these two columns.
>
> At the moment the table only has 493 rows in it. Ive heard only to put
> indexes on large tables, with more than 1000 rows in it to improve
> perforce. Otherwise indexes can be an overhead.
>
> Many thanks for any advice!
>
> Thiko!
Rebuild the table as an IOT and the entire problem goes away.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon May 23 2005 - 21:10:35 CDT
