Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256

    Unanswered: query performance almost zero

    All of a sudden a quite fast query one of my users executes is suddenly almost halted in its steps. After reading some 30.000 rows the query is almost dead in the water and I am observing row-level locks (Next key share lock) on both fact and dimension table.

    Each time the query is run, it halts at the same amount of rows read?

    Anyone a suggestion on the cause?
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    Ah, forgot to update the statistics on the other tables involved. That really seems to be a show-stopper...........
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

Posting Permissions

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