Hello All;
I have huge data like
Data is like this --> Firstname || Lname ||Address1 || Address2 || Address3 (900 Fields)
I used Union all like below and creating view for below script
I have 40 Union all
Select Firstname,
Lname
Address1
from Table1
Union all
Select Firstname,
Lname
Address2
from Table1
Select Firstname,
Lname
Address3
from Table1
The sql is running for long time and total records in table1 is 4M
It is running for long time when I want to check count or used in other script while joining.
Is there any other way I can run this script faster. I used unpivot and even it is taking longer time.
Thank you
Message was edited by: user13034857