topic Performance Problem In BSIS Table in Application Development and Automation Discussions

Performance Problem In BSIS Table

Former Member — Sat, 25 Apr 2009 12:25:14 GMT

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 — Sat, 25 Apr 2009 17:23:26 GMT

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

ThomasZloch — Sat, 25 Apr 2009 22:17:12 GMT

BSIS is a transparent table, neither clustered nor pooled.

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

Thomas

Former Member — Sun, 26 Apr 2009 09:07:56 GMT

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.