cancel
Showing results for 
Search instead for 
Did you mean: 

Table Size Category

Former Member
0 Kudos

We have a table (FMIFIIT) which has 15,000,000 records. This table is sized at level 4, which is 40,000 to 160,000 expected records. Obviously, performance is very slow on this table. Will increasing this size category speed up performance? If so, are other steps involved? If not, what other options other than indexes can we take. We are running ECC 6.0 and Oracle 10g

Thanks,

Blake

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Changing the table category now will not improve performance.

It is just a hint for the DB tools to size the tablespace next extent at installation.

Check to see if the indexes need to be reconstructed and check to see if the table needs to be reorganized.

And check if you need to add one index.

Regards,

Olivier

Answers (0)