Thread: Replace UniqueIdentifiers with Ints in existing DB
View Single Post
  #5 (permalink)  
Old 06-29-09, 13:00
gvee gvee is offline
www.gvee.co.uk
  
Join Date: Jan 2007
Location: UK
Posts: 10,002
Pat,
I take it you use sequential GUIDS then?

Due to their random nature GUIDs are considered poor candidates for indexes as they cause frequent page splits.
__________________
George
Twitter | Blog
Reply With Quote