Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Db2curiosity

    DB2 not picking up right index for right query - detail below -Pl help

    Hi, we are doing the 2 following updates in DB2 8.1,the index meant for 1st update is getting used in 2nd update and making it very slow. ** Table c has 7MM rows. ** Table w has 300K records. ** RUN STATS are Current for both tables. ** REORGCHK on table c has been done and it looks ok /** For...
  2. Db2curiosity

    Prepare Execute is not doing anything but no error message

    Hi, We are encountering a strange situation which using PREPARE and then EXECUTE for a dynamic INSERT statement. The Stored proc is not returning any error but the insert is not happening. We tried running the INSERT statement outside and its doing fine .. do you have any idea why the thing is...
  3. Db2curiosity

    Queries with SELF join is slow,though the PLAN is very good

    Hi, I wrote last week about some costly queries and kind of tuned them by adding a NEW index with all your valuable help. Looks like the story didn't end here. There are another set of queries [which is having SELF JOIN on a 25 MM table]Its picking up the NEW index,showing improvement in...
  4. Db2curiosity

    DB2 Performance is slow /spooky even with Index usage - help

    Hi, 1> i have a composite index I1 on column A,B,C,D,E out of which A,B is present in where clause and column D is also present in where clause but with a <> operator. The query plan is showing INDEX I is being used still the query is kind of slow ... any tips for improving? by the way ,i...

Part and Inventory Search

Back
Top