Skip to Content
-1

using same table multiple times in SQL SCRIPT using amdp

Apr 25 at 04:36 PM

30

avatar image

Hi,

i created a amdp where i have used a single table multiple times to fetch same columns distinct values into different fields.So my question is doing so does it effects any performance?

2)i have also joined nearly 9 tables in a single join does it effects any performance in sql does i should break it into multiple tables and write the select.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers