-
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 ?
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
-
hi
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.
-
Originally Posted by oferoh
it can be happened.
do u have any experience on huge data base?
25m rows is hardly a database.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|