< snip >
>But seperate a key concept(s) in indexes are
>- to keep them as compact as possible (less rows need to be scanned off disk and less memory needs to be used.)
>- if the index does not have many different values i.e. only 0 or 1 use a
bitmap index.

another question -- in 8i can you use bitmap indexes across partitions?