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

Thread: query running slow.

  1. #1
    Join Date
    Nov 2001
    Posts
    110

    query running slow.

    1.At what record numbers in a table should partitioning be considered.

    2. I have a query running against a table with 14 million records and a predicate against a number column that is indexed but is running very slow(74ms). Any ideas on how to resolve this

    3. Any other solutions in addition to a partioning scheme.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    1. There is no magic number for this. Partitioning is just a tool that can be used to help load bulk data, query bulk data, manage bulk data, or a number of other things, but it's not a solution for all problems.

    2. How many rows is it returning? To find out why it takes this amount of time you need to do some analysis of the waits involved, ad for that you need to read up on event 10046 tracing. a google search ought to suffice, or look at http://asktom.oracle.com

    3. You need to disgnose (ie. identify and measure) exactly what the problem is before dabbling with partitioning or any other remedy.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    All that good stuff being said, a table of 14 million rows wouldn't ring my bell for partitioning. 140 million, maybe.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by marist89
    All that good stuff being said, a table of 14 million rows wouldn't ring my bell for partitioning. 140 million, maybe.
    It might do if every query selected about 10% of table rows and there was a potential partitioning scheme that allowed partition scans instead of table scans. But it's all hypothetical.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: query running slow.

    Originally posted by Natik
    . . . is running very slow(74ms)
    Not sure 74ms can be called very slow. This might include 3 or more disk accesses, and how about parsing?

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