Performance Problem In BSIS Table

[Former Member]

Hi All,

I am facing a problem while fetching data from BSIS Table .Since it is a Clustered Pool Table.

Any alternate solution for it.

Regards,

Kapil.

[Rui_Dantas]

What info do you already have, and what do you want get from BSIS?

[ThomasZloch]

BSIS is a transparent table, neither clustered nor pooled.

Describe your problem properly, if you expect any meaningful help.

Thomas

[Former Member]

Hi Kapil,

BSIS is a Transparent Table.

There are many fields which make the Primary Key. So you may pass as many key fields as possible in your WHERE clause.

You may also use Index of the Table. If you dont have any Primary Index then you can create your own index with the fields which you require.