Primary Key

[Amanda Denning]

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]

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.