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?