performance point while fetching from bsad table

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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