Skip to Content
0
Former Member
Apr 07, 2010 at 05:54 AM

BSIS Performance Issue

45 Views

Hi,

We are facing the issue of long Runtimes for programs accessing the BSIS table. We can see that the SQL statements are using the correct index to access the records but the time duration of their run is still very long.

The size of the BSIS table is 175 GB now. And the number of rows in it is about 493 million.

We are not sure whether the huge size of this table is causing this performance issue.

*OWNER* *TABLENAME_ *GROSSMB_

SAPPRD BSIS 176413

Number of records :- 492805300 Rows :- 493 Million Rows

Is there a specific limit or a range upto which we can allow the BSIS table go grow ?

Regards

Arun