Skip to Content
0
Former Member
Jun 26, 2007 at 01:58 PM

Question of understanding MaxDB 7.6.36 & select count (*)

125 Views

Hi all,

we do a

SELECT
  COUNT(*)
FROM
  "/BIC/FTABLE"

which lasts very long in my opinion.

The explain shows an index scan with an only index access and a high pagecount.

TABLENAME     COLUMN OR INDEX     STRATEGY               PAGECOUNT
/BIC/FTABLE   /BIC/FTABLE~02      INDEX SCAN             79669
                                  ONLY INDEX ACCESSED
SHOW                              RESULT IS COPIED, COSTVALUE IS 79671

The file directory counter entries for the table do exist, so why is this access so slow?

Anybody any idea?

Thank you.

Best regards

Christian