Why would performing an index fast full scan 430 times, reading 38MB and getting back 297 rows cause a query to take almost an hour?
Why would performing an index fast full scan 430 times, reading 38MB and getting back 297 rows cause a query to take almost an hour?