June 19, 2024 at 7:34 pm
(SELECT Column1
FROM Table1) as --5
Table1_1
ON table3.Column1 = Table1_1.Column1
LEFT JOIN
(SELECT Column1
FROM Table1
GROUP BY Column1) As --6
Table1_2
ON Table1_1.Column1 = Table1_2.Column1
Could you Please let us know how to optimize above sub Queries
June 19, 2024 at 8:21 pm
Your code looks incorrect at the top.
Short answer: Index on column1 for the tables, as this will lower the amount of data you search.
Longer answer, please provide better DDL and some data along with where you find a problem or what doesn't work well.
June 20, 2024 at 1:42 pm
We definitely need more information, because, as currently written, the second table is completely unnecessary.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy