topic Re: performance point while fetching from bsad table in Application Development and Automation Discussions

performance point while fetching from bsad table

Former Member — Mon, 27 Nov 2006 09:02:00 GMT

i am using Bsad table for fetching data but the problem is that i am not using the full index of that table in where condition. could anyone please suggest me any alternate way to enhance my performance while fetching data from BSAD table

Re: performance point while fetching from bsad table

Former Member — Mon, 27 Nov 2006 09:09:15 GMT

Post your code where you do the select on BSAD table.

The solution depends on how you need to read that tables, anyway you should use the company and vendor code if you want good performance.

Max

Re: performance point while fetching from bsad table

Former Member — Mon, 27 Nov 2006 10:34:02 GMT

San,

As max told please post your query for more clarity , but a suggestion is

do select all available records with where class fields in index then filter out that in program then will be faster .

Or if more programs can use then create a new index .

Regards

R. Ramvelu