Membership and Profiler in ASP.NET
Whenever you are using Sql Membership and Profiler classes - Trying to generate reports make sure your query’s WHERE clause is using “indexed” column names at least.
Let’s look at some of the more used tables. The index of some of the tables is given below:
Table: aspnet_membership
-
Clustered Index =
ApplicationID
,LoweredEmail
-
NonClustered = UserID
Table: aspnet_users
-
Clustered Index =
ApplicationID
,LoweredUserName
-
NonClustered Index =
ApplicationID
,LastActivityDate
-
Primary Key =
UserID
Table: aspnet_Profile
- Clustered Index =
UserID