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 |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2008-04-11 : 07:28:43
|
| I have a database with tables with GUID's als primary keys.Because of the uniqueness GUID's are a performance hit on INSERT records.So I wanted to use NEWSQUENTIALID() to make INSERTS faster.Does NEWSQUENTIALID() increase performance as well with SELECT statements? Or is the benefit between NEWID() and NEWSQUENTIALID() only when INSERTing records?Henri~~~~There's no place like 127.0.0.1 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-11 : 09:13:29
|
| http://www.sqljunkies.ddj.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scukMadhivananFailing to plan is Planning to fail |
 |
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2008-04-11 : 09:31:44
|
| Thx, but this link doesn't answer the question: Does non-sequential GUIDS affect data-retrieval performance? Or is NEWSQUENTIALID() just to make INSERTS faster?Henri~~~~There's no place like 127.0.0.1 |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-11 : 09:37:13
|
| depends on the data retreival.if you're doing range scans then the sequential guid is better.if you're doing singleton lookups then it doesn't matter._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
GUID performance