Tuning view [message #574981] |
Thu, 17 January 2013 05:55 |
mvmkandan
Messages: 68 Registered: May 2010 Location: Trivendrum
|
Member |
|
|
Hi Experts,
I have created a View in Oracle DB and I designed one form in Oracle D2k. In that form, i have 3 data block. All are to be populated from the same view based on filertaion given in where condition.
I need to filter the grid (three blocks), based on the param selected on that form.
I executed the view in DB,it took just 350 milliseconds only. But I put more where conditions for the parameter sected. So it get very slow.. it took near about 3 minute to load the data in screen.
My Where conditions psedeo Code is in datablock is
SourceTable = 'Block1'
And Col1 = NVL(:header.param1, Col1)
And Col2 = NVL(:header.param2, Col2)
And Col3 = NVL(:header.param3, Col3)
And Col4 = NVL(:header.param4, Col4)
And Col5 = NVL(:header.param5, Col5)
And Col6 = NVL(:header.param6, Col6)
Like this i wrote the code in each data block where field.
Could you please any one give your suggession to speed up this.
Thanks
Veera
|
|
|
|
|