Schema - Do you avoid using indexes on RowGuid column?
Updated by Brady Stroud [SSW] 1 year ago. See history
123
No component provided for introEmbed
Another little annoyance with RowGuids is when you are searching for one. You can't use > or < on a RowGuid column.
Note: There are not many cases where a RowGuid should have an index on it.
Be aware that SQL server adds this column when you perform merge replication. There are not many cases where this should have an index on it.
Acknowledgements
Related rules
Need help?
SSW Consulting has over 30 years of experience developing awesome software solutions.