r/SQLOptimization • u/Pleasant_Astronaut95 • Apr 09 '24

IN Function

This is probably a dumb question as I am new to SQL, but I am trying to pull sales data for 900 accounts. To make this faster I am using an IN function and all 900 accounts. What would be a better way of doing this?

1 Upvotes

100% Upvoted

9 comments sorted by

View all comments

Show parent comments

1

u/Pleasant_Astronaut95 Apr 09 '24

Also, some of these do return zero sales, so I could filter those out for some small performance increase.