Performance issue with PasswordResetToken

Description

Password reset may time out on sites with many users.
This is caused by GetUserByPasswordResetToken sproc, which has to perform a full clustered index scan.
I suggest adding a dedicated filtered index on PasswordResetToken (Not Null) and set PasswordResetToken = Null (and PasswordResetExpiration = Null) whenever it is timed out or used, to keep the filtered index small.

QA Test Plan

None

Assignee

Unassigned

Reporter

Sebastian Leupold

Story Size

Unknown

Severity

Major

Triage

New

Reported in Build #

None

Fixed in Build

None

Dev Owner

None

Includes Code Fix

No

Documentation Required

None

Trouble Ticket

None

Requires More Info

None

QA Story Points

None

QA Owner

None

Injected

None

Automation Required

None

Code Review Owner

None

Priority

High
Configure