| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Basic INDEX and SELECT questions
AFAIK,
1) Index order creation is not material, the type of index that you
select for the cardinality of the field is material. use Bitmap index
if field has low cardinality, use B Tree index for fast indexing and
fields with high cardinality.
2) The more the indexes on a table, the more reindexing will have to be
done frequently if large data is inserted, deleted etc. so you should
be moderate with indexes.
Received on Wed Sep 07 2005 - 23:16:58 CDT
 |
 |