Primary Key

23 views
Skip to first unread message

Amanda Denning

unread,
Aug 12, 2019, 11:59:09 AM8/12/19
to ELMAH
I have tried running searches about this topic and haven't found anything yet.  Just wondering if there was a specific reason why there isn't a clustered index in the script to set up ELMAH_Error?  We were running some various scripts when an auditor came in and he asked why we didn't set up a clustered index.

Thank you

Atif Aziz

unread,
Aug 12, 2019, 2:24:00 PM8/12/19
to el...@googlegroups.com
It's not set up as a clustered index because the ErrorId is a GUID that's generated via NEWID() and clustered indexes perform best when the primary key is sequential in nature.

I would recommend searching for “sql server uniqueidentifier clustered index” and reading a few articles to understand the choices and performance impacts.

- Atif

On Mon, Aug 12, 2019 at 5:59 PM Amanda Denning <aden...@jasperengines.com> wrote:
I have tried running searches about this topic and haven't found anything yet.  Just wondering if there was a specific reason why there isn't a clustered index in the script to set up ELMAH_Error?  We were running some various scripts when an auditor came in and he asked why we didn't set up a clustered index.

Thank you

--
You received this message because you are subscribed to the Google Groups "ELMAH" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elmah+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elmah/5b22f934-fc06-4e18-adc7-aae34fb45ec2%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages