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 2005 Forums
 SQL Server Administration (2005)
 Query cost (relative to the batch) problem

Author  Topic 

SQLdodo
Starting Member

4 Posts

Posted - 2009-03-15 : 10:43:48
Query cost (relative to the batch) always showing 100% no matter what query I ran.
I'm not sure that this is a normal SQL Server behavior.
Couldn't find anything on google that relates to this problem and TBH I'm not sure this is a problem in the first place.

Hope there is some explanation to this.

[url]http://img3.imageshack.us/img3/2484/querycostf.jpg[/url]

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-03-15 : 10:48:55
Yes it is.Looks like your index hasn't been used.
Go to Top of Page

SQLdodo
Starting Member

4 Posts

Posted - 2009-03-15 : 10:53:04
Heh, OK.

Thnx
Go to Top of Page
   

- Advertisement -