Printable View
hi to all
i have table with 25M AND 80 column on oracle g11
i have query on first name varchar(128) and i create bitmap index its take 0.1 - 0.9 sec , the query is seek
but i need to make it more faster .
some one can tell me how to handle with that or suggest me ways ?
ofer
you find your wait events and tune them -but if you think you are going to get better performance frm 0.1 to 0.9 seconds - you are probably in la la land
it can be happened.
do u have any experience on huge data base?
bitmap index? Why?
Is that a FACT table in a Data Warehouse?
Is somehow your query taking advantage of star-transformation?
Are there other bitmap indexed columns included in your predicate?
What is the cardinality of your first_name bitmap index?
25m rows is hardly a database.Quote:
Originally Posted by oferoh