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