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