Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Unanswered: Query data slow in case a few data

    Dear sir ,

    I have big problem in DB9.5 workgroup

    When I query a few data.The DB has response to slow
    but I query large data The DB has response to fast

    What is this problem and resolve it?

    P.s. I have been create index and run stat.

    Thk.

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    try explain. if that does not help you then you should find answer on page 193.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by dav1mo View Post
    page 193.
    page 193 of???
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    of 300
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Mar 2010
    Posts
    2
    Quote Originally Posted by Cougar8000 View Post
    of 300
    What is URL ? I don't know it.
    Please Tell me .

    Thank you so much.

  6. #6
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    Sorry about that, but Cougar and I could not help but be sarcastic, though it would have been better for Cougar to have given a tiny URL to point you to the movie 300.
    You did not ask a real question that anyone could give a beneficial answer. If you would like help on a question you have to be more specific. The general things you should do when you have a slow query is to review the SQL. You run an explain of that SQL statement to see how it is accessing the database, is it using indexes or scanning every row, do you have a cartesian or partial cartesian product (you are not joining tables by the key or only by part of the key that links the tables), you are, maybe materializing a huge intermediate resultset, maybe your bufferpools have zero memory allocated to them, maybe you are having problems with your disk I/O rate, etc... You gave us no information to help you.
    Maybe you need to look at some of the items I mentioned above, maybe the SQL being executed is just poorly written, give us the query, ddl of the tables being queried, some sample data and expected results.
    Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •