I'm not very familiar with databases and need your help. We have following case. Informix DB is running and target table contains 1.5 million records. We want to run application which periodically selects certain information from this table. We have only read access and we cant use triggers. How can I test or benchmark for e.g simple SQL:
select id from statedetail where resource = '1';
Whether or not running this query periodically affects the overall system on InformixDB or not.