on 03-10-2009 5:26 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.