Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dense and Sparse Index
Hi All,
I would like to know when does dense index and sparse index get built up in oracle. Are there any expilict keywords for these index constructions? I have read that dense index is faster with integer columns and sparse index for varchar2 columns. Please clarify me.
Thanks in advance,
Ramesh
Received on Mon May 17 2004 - 06:22:31 CDT