Great question! First thing I check is whether SELECT * is being used...that alone can explain most slowdowns. After that I look at WHERE clause filters to see if any functions are wrapping columns (which kills index usage), then check if there's a…more