Hmm my UT query about my Crosstab Query is also running very slowly :(

I may end up having to get a job more suited to my talents.

Ice Cream Vendor perhaps.


>My crosstab query is running very slowly compared to the same query running using the Pivot Table wizard.
>
>Is there any reason for this.
>
>I have put indexes on the 2 fields required for the crosstab but to no avail.
>
>We are talking about 50 times slower than the Pivot Table Wizard.
>
>Many Thanks