Hi, I want two sql queries build against sql north wind database, for
both queries the result should be same
But for one query time
taken to execute should be more when compared to the other one
can
any one please frame and give me such type of queries atleast one pair
or more
Loading
ShankeyPosted Aug 27, 2010, 6:31 AM
You can try following sample queries and can identify the time difference in executing these query (Please dont forget to mark my answer as accepted if it helped you :) ).
- select * from syscolumns
- select * from syscolumns(nolock)
for further detail you can read benefits of using "nolock"