How can i compare query X and Y and say that X is better then Y when they both take almost the same time in small cases scenarios???
the problem is that i have 2 queries that are suposed to run on a very big database, so run a evaluate is quite not a option (aka try and fail method), so we created a small database to perform some tests... and now the evaluating wich query is the best
is a problem since on our test base they run almost the same time: 5 min so... besides the time taken to return, what is another way to measure how good a query is???
View Complete Post