Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    16

    Unanswered: count(*) taking much longer time than the column list

    Hi,

    I'm executing a query on DB2 EE V7.2, which has more than 2 joins involving 3 tables. Surprisingly, if I fetch the column list, its execution time is less while if I simply replace the column list by count(*) it is taking almost 10 times the previous query. Ideally it should be the other way round !!

    Any pointers to this problem ???
    Regards,
    Buddy Amazing
    IBM Certified DB2 DBA/AppDvlpr

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Can we see the SQL statements and list of indexes?

Posting Permissions

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