Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Indexes on columns < 1000 rows

Indexes on columns < 1000 rows

From: Thiko! <biwombi_at_hotmail.com>
Date: 23 May 2005 05:43:55 -0700
Message-ID: <1116852235.944228.132600@g14g2000cwa.googlegroups.com> 





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!
Received on Mon May 23 2005 - 07:43:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US