Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
1  
Your goal seems unclear to me. Is it to identify how long certain queries run? Is it to identify whether the creation of an index improves a class of queries? Is this a general purpose how do I establish a baseline and then measure query performance against that... – billinkc Nov 20 '12 at 16:29

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.