Need help in sql query optimization

SQL Server Administration
1

I have below sql query which is running quite slow.used 3 tables in conjunction and have created first table a with same set of columns and 1 different and b table with same set of columns and 1 different and then joined these.Please help in optimizing or any other way to acheive the same.

sql%20query
sql query.png2560×1440 214 KB

2

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

3

why are you spamming?

4

not spamming yosiasz :slight_smile:

just want to "GET" ... my reply to "nikita"

you can something like "repeating"

5

My reply was to Nikita.

6

oh ok got you !!! :slight_smile:

7

is this forum for help?