Fetching data slow from MSEG and BSEG table

[Former Member]

Dear Experts,

Out MSEG and BSEG are major tables which are very slow and taking 5-10 minutes in fetching just 20/30 records.

Why this table taking more time and how I can fatch fast data from these table.

regards

[Former Member]

Hi...

These tables are very important and huge tables for MM & FI entries, while you accessing these /any table try to use the Keys,

if any case if not possible, create indexes on these tables, it will be very much fruitful .

or reorganize the tables by using BRTools.

Cheers

KHS

[markus_doehr2]

> Out MSEG and BSEG are major tables which are very slow and taking 5-10 minutes in fetching just 20/30 records.

> Why this table taking more time and how I can fatch fast data from these table.

Do you select on key fields or on indexed fields? How do you select?

If not, then the database must read the full table and check which of the entries are valid for your selection.

Do an SQL trace using ST05, run the command, stop the trace and check the explain.

Markus

[Former Member]

Hi,

You can probably check the option to rebuild the indexes and recreate the stats for both the index and tables.

If you are using oracle , you can use the report RSANAORA

Thanks,

Jagadish

Edited by: jagadish gudla on May 25, 2011 3:35 PM

[former_member182034]

Dear,

first check the red trace of transaction with ST05 then You have to update/create statistics of these tables( MSEG, BSEG) with DB20 and also update the indexes with Activate and Adjust database via SE14,

Regards,