best performance quries
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 ?
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
25m rows is hardly a database.
Originally Posted by oferoh
Click Here to Expand Forum to Full Width