How i optimize my matrix report [message #88821] |
Thu, 10 April 2003 02:05 |
Muhammad Aurangzaib
Messages: 43 Registered: April 2003
|
Member |
|
|
Dear Friends
I have matrix report having more then then nine matric columns and rows are above 3000. it delay at intilizing report almost 1 to 2 mints and then it delay on formating pages and then it give gives result.
Note that i use the query with optimar hints and have check the result throught explain plan and trace ..it give the right time result ... i mean no delay...
would any one give suggestion or tips how i optimaze my report at running mood
thx
itroome@hotmail.com
|
|
|