January 31, 2012 at 3:37 am
When I run my query in a large table for the first time it takes a long time but subsequent running of the same query takes lesser time.. Is it because same pages are used?what would be the reason for this?
January 31, 2012 at 3:46 am
Data caching and plan caching
First execution data has to be pulled from disk and plan has to be compiled. 2nd execution both data and plan come from cache.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 31, 2012 at 3:50 am
Can you point me to some documents where I can know about execution plan and how query is actually executed.
January 31, 2012 at 4:31 am
duggal.priyanka06 (1/31/2012)
Can you point me to some documents where I can know about execution plan and how query is actually executed.
Get the book SQL Server Internals for SQL Server 2008 OR Inside SQL Server for SQL Server 2005.
Get the book SQL Server Execution Plans by Grant Fritchey to learn about execution plans (available on this same site in books section).
January 31, 2012 at 4:35 am
Divine Flame (1/31/2012)
Get the book SQL Server Execution Plans by Grant Fritchey to learn about execution plans (available on this same site in books section).
The free PDF is here: http://www.red-gate.com/our-company/about/book-store/assets/sql-server-execution-plans.pdf
I believe Grant is rewriting this, but it is still a good introduction to the topic.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
January 31, 2012 at 4:37 am
thanks all for your replies
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply