Skip to Content
Former Member
Mar 11, 2010 at 08:28 AM

get number of table scans



in DBM-Gui there's the activity overview of some statistical data, amongst others the number of table scans / index scans. I have two questions regarding this numbers

a) what's the sql statement to fetch the data, and (much more important)

b) we need the data on table level, e.g. number of table scans for table A, table B, ... Is this possible ?

many thanks in advance...GERD...

PS: MaxDB (on linux)