Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 execution plan

Author  Topic 

ryanoc
Starting Member

25 Posts

Posted - 2006-07-05 : 17:03:19
I did a "Display Estimated Execution Plan" using sql2005 and it was much smaller of a diagram. Both were the same for the different dbs also. One other thing I noticed was that I ran the query for the first time in a few hours and it took over 20 seconds to execute. After that it ran instantly everytime.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-05 : 17:03:54
What is your question?

Tara Kizer
aka tduggan
Go to Top of Page

ryanoc
Starting Member

25 Posts

Posted - 2006-07-05 : 17:04:15
sorry about this post, i ment it to ba a reply to another topic :)
Go to Top of Page
   

- Advertisement -