Loading

Hey i want some sql queries with their optimized queries

Pramod Kumar Nandagiri

16y2.5kSQL

hi friends,
i want some sql queries with their optimized queries, means two queries should retrieve same result from sql 2005 database but one query performance should be more than the other
i need such type of pairs of sql queries can any one please help me on this
here i am attaching ont ppt file , in this optimized queries r there for the oracle database but i want this type of optimized queries for the sqlserver 2005 database, see the ppt file

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Shankey16y ago
Accepted answer
Hi Pramod Kumar,

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.
1. select * from syscolumns
2. select * from syscolumns(nolock)
for further detail you can read benefits of using "nolock"