Sybase Certification Interview Question:

Suppose The titles table has 50,000 rows and a nonclustered index on the price
column. Which of the following queries use less logical I/Os?
A. select "Min" = min(price), "Max" = max(price) from titles
B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
C. They will both use the same number of I/Os

Submitted by: Administrator

B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
Submitted by: Administrator