hi
I have a crosstab with about 6 rows of record. When I did a preview of the crosstab, it load quite fast.
But the moment I added a row number function, it takes about slightly less than a minute to load.
And when I remove the row number function, everything works perfect.
And I again added the row number function, it is slow to display the crosstab.
Why is it so? What should I do to speed up?
Thanks a lot.
I have a crosstab with about 6 rows of record. When I did a preview of the crosstab, it load quite fast.
But the moment I added a row number function, it takes about slightly less than a minute to load.
And when I remove the row number function, everything works perfect.
And I again added the row number function, it is slow to display the crosstab.
Why is it so? What should I do to speed up?
Thanks a lot.