Making sure tables are indexed properly

[aaronburro]

My Crystal reports are taking an assininely long time to run, and it has been suggested that I check the "datamap" to make sure it is properly indexed. We are aparently using the ProvideX based version of MAS200.

How would I go about doing such a thing? And, most importantly, what do I need to know in order to make sure that I don't break anything?

 

[Blorf]

No indexes are available for crystal reading into MAS.

So, you can increase performance a little by telling crystal not to use indexes at all. I think the setting is use or not use server side indexes. Turn it off and see if it helps.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.