Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bitmap index distinct key limitations

Status
Not open for further replies.
goodmans

goodmans

MIS
Apr 23, 2008
63
GB
Hi Oracle Gurus

I have a big table with 125 columns and holds 100 million records.

I like indexing one of the columns that is having 15,415 distinct keys.

What index do you recommend on this column bitree or bitmap index. I guess bitmap is fine what do you say?

Regards
G
 
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
1K
SkipVought
S
kernal
  • Locked
  • Question
Is there any way to write a select statement for distinct when there is a CLOB field? 2
Replies
4
Views
414
john parker
john parker
IanWaterman
  • Locked
  • Question
Find tables without a Primary Key 1
Replies
2
Views
168
IanWaterman
IanWaterman
Shelby500
  • Locked
  • Question
UPDATE that uses DISTINCT
Replies
4
Views
381
Shelby500
Shelby500
slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
187
taupirho
taupirho

Part and Inventory Search

Sponsor

Back
Top