How can I improve the Report Module

From: Samuel <seatechk_at_iohk.com>
Date: Wed, 23 Feb 2000 16:26:34 +0800
Message-ID: <38b39947@news.iohk.com>

Dear All,

I have a scenairo here and I think you all guys had faced it before. Can you tell me what your experience are?

Scenairo:
Consider we have a sql which will be used by many users and their input parameters are different. So it means that the sqls which are issued by users with different parameters are needed to re-parse.

In this situation, how can I reduce the need of re-parse operation? If I create an view with no filter parameters (e.g. a = '1') (assume the sql contains more than two tables) and then create a new sql with parameter to query this view, will it improve the performance? The question is the procedure of the execution? Will the view's sql merge to the new query before parsing it? If yes, it means that we cannot re-use the execution plan.

Any idea?

Samuel Received on Wed Feb 23 2000 - 02:26:34 CST