I have a feeling we should ask for examples of slowness before suggesting too many solutions.
Crosstabs are nasty anyway; you're usually doing a bunch of group-by's to get "raw" data for the
grid, then transforming that into a real grid client-side. Any point along the way could be slow.
If the group-by's are done incorrectly, there might be more data being transferred for client-side
transformation than necessary; indexing might need to be done, but it may not be the cause of the
problem.

If Miranda could provide us with more details, perhaps? Quantities of data in the original source,
types of queries being run, approximate time taken by the process at various stages?

-Philip