validation of a info provider

Hai All,

A quick question. If I design a cube or a multiprovider, how do I decide that its designed for better performance and how do I know the loop holes in my design? I know that there are some best practices and recommendations regarding building these infoproviders. But is there any way that I can check the performance? May be like running the queries and measuring times etc... any suggestiosn are appreciated.

Thanks.