sql - Which Select query will run faster -

-

this question has answer here:

hi trying maximum id table has approx 1 million records. please suggest me on of these query execute faster.

option 1:

select top 1 surveyuserresponseid surveyuserresponse order surveyuserresponseid desc

option 2:

select max(surveyuserresponseid) surveyuserresponse

as per actual execution plan both query took same time execute.

you can try yourself. run query time statistics. so:

set statistics time on; select top 1 surveyuserresponseid surveyuserresponse order surveyuserresponseid desc set statistics time off;

and see on "messages" tab how long took execute each query.


Comments

Post a Comment

Popular posts from this blog

Prolog - Listing -

-
i have problem trying work out code here. let's have these codes: university('university of cambridge', 1, 'united kingdom', 90.3, 92.8, 89.4), university('university of oxford', 2, 'united kingdom', 88.9, 94.8, 88.0). how list out names of universities only? tried doing listing. , listing(university). list out or rules. trying names like: university of cambridge university of oxford this gives 1 name: ?: university(x,_,_,_,_). you can query more ; or space to print of them, use fail driven loop: ?: university(x,_,_,_,_), write(x), nl, fail; true.
Read more

orchardcms - change base url in local copy in Orchard CMS -

-
i want copy website (orchard 1.7.2.0) localhost, test things before on live site. ik copied database , de web directory , configured iis. in orchards database changed base url in settings_sitesettings2partrecord table. changed database connection in settings.txt now when enter new base url in browser redirected original url. how can prevent this? can't find other reference original url. thanks in advance answer. i found out went wrong. there rewrite in database originial url (for removing www in url). removed , works.
Read more

python - More Issues with overlapping labels in Tkinter -

-
i having problem tkinter. issue follows. i retrieve information database. wish print out based off few user selections. want print out columns a, b, c want print out columns, a, b, c, d want print out columns a, b, d, e also, when query, not know ahead of time how many results have. queries give 1. give 200. print them, this... while x < results.num_rows() : result = results.fetch_row() author = result[0][0] title = result[0][1] conference = result[0][2] year = result[0][3] location = result[0][4] label(root, text=title).grid(row=startrow,column=0,columnspan=5,sticky=w) label(root,text=author).grid(row=startrow,column=6,columnspan=1,sticky=w) label(root,text=year).grid(row=startrow,column=7,columnspan=1,sticky=w) label(root,text=conference).grid(row=startrow,column=8,columnspan=1,sticky=w) ...
Read more