DSXchange

Hi evryone!!!!!

Could you please suggest me measures i have to consider while using pivot.

I am saying of using 91 rows for pivoting....

Are thre any performance implications?

How can i overcome it....

Could you please help me out on this issue...

Thanks and Regards,

Alan

Welcome aboard.

There are no performance implications.
Processing 91 rows will take longer than 0 rows and less time than 10000 rows, but that's not a performance implication.

Do you mean 91 columns?
In that case make sure you have plenty of memory, otherwise it will need to use scratch space on disk. How many of those columns are pivot keys, how many are pivot columns and how many are pass-through columns. Each of those answers will affect total throughput time, but it doesn't matter because no estimating tools exist.