DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: best performance quries

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  3. #3
    Join Date
    Feb 2009
    Posts
    2

    hi

    it can be happened.

    do u have any experience on huge data base?

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by oferoh View Post
    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
  •  


Click Here to Expand Forum to Full Width