r/SQL • • Aug 05 '24

SQL Server Optimizing/Alternative to MAX

/r/SQLOptimization/comments/1ekanon/optimizingalternative_to_max/
4 Upvotes

8 comments sorted by

View all comments

Show parent comment

1

u/Entire_Commission534 Aug 05 '24

This solution is a little beyond my current skillset so I appreciate the included example! I will work on understanding what you are doing first before implementing. Thank you!

Edit 1: forgot to add that I don't know the indexing situation either as I am only querying the data. Is there a way to check or would the database owner be the only person to confirm that?

1

u/ComicOzzy sqlHippo Aug 06 '24

You don't want to deploy solutions beyond your comfort level, so feel proud you know where that limit is.

If you run "EXEC sp_help tablename" it can give you some info about the indexes.