topic Re: performance issue using bsec table in Application Development and Automation Discussions

performance issue using bsec table

Former Member — Wed, 17 Jan 2007 09:21:31 GMT

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

Re: performance issue using bsec table

Former Member — Wed, 17 Jan 2007 09:25:20 GMT

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

Re: performance issue using bsec table

Former Member — Wed, 17 Jan 2007 09:28:33 GMT

Hi,

Please follow the link for the resolution.

~Mayank

Please reward points if its helpful.

Re: performance issue using bsec table

Former Member — Wed, 17 Jan 2007 09:41:39 GMT

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

Re: performance issue using bsec table

Former Member — Wed, 17 Jan 2007 09:48:05 GMT

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.