Hi, My physical table is partitioned based on region name like 'MG' , 'UG','DG' and 'PG'. Kindly provide me some examples of how should i write the fragmentaion criteria either in BMM layer or Phycial layer? Regards Debyani

Hi, The concern is RDP is already designed (including physical tables, logical tables..etc) and it is not using the functionality of table partitioning. And now i have to implement this without redesigning the RPD from scratch. Can i use partition table selection dynamically using the session variables.?? Regards Debyani

Hi , This a sample query for your reference. The below query is in View table of Physical layer in Repositiory. I have added table partitioning for DG group "P1_DGVCL" but how to do that dynamically for other groups based on User login Id? SELECT COUNT(*) PAID_PENDING, 0 PAID_PENDING_RE, 0 NON_SURVEYED, 0 UNPAID_SURVEYED,…

Hi Akansh, How to implement this fragmentation technique ? It will be helpful if you give few example. Also as which partition of Table it will access whether MG /UG/DG/PG partition of table is dynamic based on the User id of the customer. How can we implement the same? Regards, Debyani

query is taking lot of time, DB is not slow. and please suggest how to redesign the RPD model for that particular report. Because the presentation , logical and physical tables and joins are already created ..How to proceed , so that i can check whether it is the query problems or join ?

Thank You!! Actually when i ran the physical query of the report taken from Manage Session. It took almost a day to fetch the data and also fetched only 17 records. Tables used in the query is already indexed. Kindly suggest how to fine tune the query.