how i improve my matrix column report generation [message #88819] |
Wed, 09 April 2003 17:04 |
Muhammad Aurangzaib
Messages: 43 Registered: April 2003
|
Member |
|
|
Dear Frienfs
Would any one suggest me how i can improve my matrix report... i give u one example...that i developed a report having matrix columns more than 9 and the row goes more than 3500 how i can improve my report generate... note that i have check my query through the explain plan and trace and i also have used the optimazar hints.. at sql it run so fast but on reports it takes time on initilize report and after format report it take near about 1 to 2 mints.
... one more some time only 300 records take much time
thx
waiting yu suggestions
itroome@hotmail.com
|
|
|