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.
| Author |
Topic |
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
 Posted - 2007-08-28 : 11:16:37
|
| I wrote some code to insert some data into a table, if the record already exists overwrite, etc. I've never done something like this soI am going to bang my head against that for a while. But when I did an execution plan I gotIndex Seek Cost : 105 %How do I get more than 100% and what does that mean?Thanks,Jim |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-28 : 11:18:53
|
Some Editions of SQL Server returns flawed values.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-28 : 11:19:23
|
the max i've seen was 852%  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2007-08-28 : 11:34:36
|
| Thanks Everybody. I'll guess I'll have to try harder to get 853%!Jim |
|
|
|
|
|
|
COST: 105%