General Discussion Undecided where to post - do it here. |
|
![]() |
#1 |
|
Hours have been spent 8 by me arguing about organic keys versus surrogate keys. We spoke to somebody who says "You must more often than not use surrogate keys for your clustered index" and then when I described my situation, she decided that if that was the situation then natural keys are most likely the greater choice. Although I do argue that you need to always use surrogates in your clustered index (which to me I believe it could as well be considered a pile, though there are reasoned explanations why that's false), she decided for my condition. Nevertheless, the folks who have been in the assembly appear to still believe surrogates are best for the situation... WTF??? It's fairly clear if you ask me that surrogates for the clustered index is going to suggest that the host is nearly always going to complete bookmark searches, with every line in the research in another site. Organic secrets, nevertheless, can more often than not suggest list attempts to a particular group of pages. I am talking about, you've half an hour of the inquiries being attempts on the normal key, and another 60% querying a variety of columns; both of which are locating nearly every line in the table, mainly because of the character of that table.
|
![]() |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|