performance issue using bsec table

[Former Member]

Hi..

I have some performance issues because i'm using the table bsec.. Can anyone suggest any alternative tables to extract the same info, to minimize the performance problems?

Thanks

Keshi

[Former Member]

Hi

U should past your code to understand which selection you need.

U should use the keys fields (company code, document number and fyscal year to improve the performance or create some indexes.

Max

[Former Member]

Hi,

Please follow the link for the resolution.

~Mayank

Please reward points if its helpful.

[Former Member]

Hi,

If you create one or several indexes, you'll get better performance in any operation if you access the table by that index item(s). It's a possible solution for your problem, exactly if you have performance problems selecting a database table, and you access it often by comparing with the fields of the index(ex) you can create.

Please be also attent that if you create new index(ex) the amount of tablespace used in the database will be greater than now, because the indexes are also new tables for indexing.

I hope this can help.

Best regards,

Paulo Sousa

[Former Member]

for BSEC table try writing Select .... Endselect which would be somewhat easy than other select statements. Also, what all keys ru using in ur where condition...try creating an index for these fields due to which it will retrieve data faster.

i think you can use simple select for any cluster tables for example i can give KONV table. the only thing you cannot make inner join with these tables.