pCloud Partner Program

SQL Server資料表使用GUID欄位考量

程式技術/Database 2014/03/14 15:34
views: 667839 times
在資料表中, 使用 GUID做為clustered index時, 很容易因為是隨機產生的值, 而導致資料存放的離散, 可以利用這個函數來改善:

NEWSEQUENTIALID()

該函數是循序地建立 GUID, 也是唯一值, 但可以降低離散的狀況, 進而改善未能有效填滿及離散的問題.

當然, 若是 GUID欄位沒有使用在 cludtered index時, 則比較不需要擔心這個問題.

參考資料:
http://technet.microsoft.com/zh-tw/library/ms189786.aspx
top

Trackback Address :: http://diary.tw/tim/trackback/1081

  1. Tracked from de gournay wallpaper knock off 2017/12/02 21:16 DELETE

    Subject: de gournay wallpaper knock off

    See top Susan Harter Mural Papers that's available plus on sale today!
  2. Tracked from china sourcing agents 2017/12/03 00:14 DELETE

    Subject: china sourcing agents

    Find here the best china sourcing consultants that are now in stock and at the best price today!
  3. Tracked from gas fire pit burners 2017/12/03 09:45 DELETE

    Subject: gas fire pit burners

    Get the best crossfire brass burners that are now in stock in addition reasonably priced now!
  4. Tracked from check it out 2017/12/03 13:15 DELETE

    Subject: check it out

    Get professional scenic background wallpaper that's in stock plus at great prices today!
  5. Tracked from get yerba mate 2017/12/04 05:01 DELETE

    Subject: get yerba mate

    Find the best Tea that are available now plus reasonably priced. Get it today!
  6. Tracked from yerba mate cancer 2017/12/08 04:18 DELETE

    Subject: yerba mate cancer

    See the hottest get yerba mate that's available now in addition at the best price. Get it today!
  7. Tracked from yerba mate cancer 2017/12/08 12:40 DELETE

    Subject: yerba mate cancer

    Find here top how to make yerba mate that are available in addition on sale. Get it today!
  8. Tracked from yerba mate recipes 2017/12/10 19:54 DELETE

    Subject: yerba mate recipes

    Find here top quality yerba mate recipes that's available now plus on sale. Get it today!

Write a comment


PREV : [1] : ... [92] : [93] : [94] : [95] : [96] : [97] : [98] : [99] : [100] : ... [473] : NEXT



Nextbit Robin 5.2吋六核心智慧型手機 Microsoft Office 365 中文家用版PKC (無光碟)
ASUS華碩 AC1900 雙頻無線路由器 RT-AC68U 美國 VORNADO 533 渦流空氣循環機 (黑色)
御茶園 每朝健康綠茶(650mlx24入) 每朝健康 雙纖綠茶(650mlx24入)


 Waiting...