0

Assume I have a table t1 and two queries q1 and q2 on t1:

SELECT xxx FROM t1 WHERE <condition-1>

and

SELECT xxx FROM t1 WHERE <condition-2>,

where <condition-1> logically implies <condition-2> (i.e., <condition-1> is stricter than <condition-2>, and the result set of q1 is a subset of that of q2)

Question:
Will the response time of q1 commonly (if ignore extreme cases) be shorter than that of q2?

This question may seem weird, the reason why I ask is I want to figure out some test oracle for the performance test. If the answer to the above question is true, that may serve as a test oracle.

Improve this question
  • What did your tests show? – mustaccio Oct 10 '20 at 12:34
  • This question may seem weird, the reason why I ask is I want to figure out some test oracle for the performance test. If the answer to the above question is true, that may serve as a test oracle. @mustaccio – haochen he Oct 10 '20 at 12:50
  • the perfmance usaully depends n your indexes and if there are xcostky functions like joins UNION and so on, further more data you retrieve mire time elapses. create3 a database and try – nbk Oct 10 '20 at 13:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.