Skip to Content
0
Former Member
Jan 22, 2007 at 09:43 AM

15 Million records in BSIS

170 Views

Dear friends,

As we know BSIS is a very crucial table, and I have 15 million entries in it. Reports involving BSIS are taking 20 to 45 minutes in execution. Even in simple SE16-->number of Entries query is taking 11 minutes to execute. So before going on tuning SQL in detail (we have already checked our abap code and we havent find any major SQL blunders in the reports

I want to first check out other options as Basis Admin like table/index partitioning, archiving option. Please guide me in these matters and are the really boost performance. I am using oracle 9205 with SAP 4.7 ext200

Regards

Waqas