Q:  

I am working with operational reports. Do you know if there is something like standards or best practices for report presentation? To improve the performance of the queries we use we can use stored procedures instead of plain SQL or improve the performance of the SQL files we already have. Which of these options are the best? Do you know other options that can help us improve operational queries?

A:  

Chuck Kelley's Answer: I will not be able to help you with presentation - 1) it is not my best skill (I hate the mouse!) and 2) I don't know of any.

As for performance, let me first say that with out a lot more information, I am not sure my answers are correct. Along with that, I am not sure of the question. If you have reports that require up-to-the-minute data, then you must use the operational system. I would probably improve the performance of the SQL files you already have. If you can't get the performance, I am not sure why stored procedures may be better. If your reports don't need up to the minute data and the data mart has the data you need, then why not just use them. Good luck!

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access