Need help in sql query optimization

[yosiasz]

why are you spamming?

Need help in Sql Query optimization

Hi You can break up the data Example if you have 100 rows use 10 rows At a time You can also filter Example if you have 100 rows Use where name = Larry to reduce to 2 rows Also You can join two tables first Get it to work fast Then join to third table These ideas are just three Please Google search You will find lots lots of articles From which you can get ideas