hello,

s their a way to retrieve the IDX_READS and the SEQ_READS of a statement or a transaction Without doint a select in the monitoring table like :

'SELECT '+
'MON$RECORD_IDX_READS as IDX_READS, '+
'MON$RECORD_SEQ_READS as SEQ_READS '+
'FROM '+
'MON$RECORD_STATS '+
'JOIN MON$TRANSACTIONS ON MON$TRANSACTIONS.MON$STAT_ID=MON$RECORD_STATS.MON$STAT_ID '+
'WHERE '+ 'MON$TRANSACTIONS.MON$TRANSACTION_ID=current_transaction',

because for every select, i need to do another select just to retrive the statistics of the select ...

thanks by advance
stephane