sql - What is the performance impact of the order property in the Index Attribute using Entity Framework 6? -


i know performance impact of property is: https://msdn.microsoft.com/en-us/library/system.componentmodel.dataannotations.schema.indexattribute.order(v=vs.113).aspx

this attribute specifies columns come in order in multi-column index. there no performance impact 1 way or other directly due attribute.

whether having multi-column index better use case not having depends on many factors cover here. if think performance benefit having multi-column index, use it.


Comments

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -