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: AdministratorB. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles)
Submitted by: Administrator
Submitted by: Administrator
Read Online Sybase Certification Job Interview Questions And Answers
Top Sybase Certification Questions
☺ | Explain When you run optdiag command on a allpages-locked table with 1000 |
☺ | Where are table/index level statistics stored? |
Top Certifications Categories
☺ | CCIE Certification Interview Questions. |
☺ | CCSP Certification Interview Questions. |
☺ | AFMC Interview Questions. |
☺ | Sun Certification Interview Questions. |
☺ | CCDA Certification Interview Questions. |