topic Re: Doubt on BSEG table in Application Development and Automation Discussions

Doubt on BSEG table

Former Member — Wed, 11 Jun 2008 10:38:23 GMT

hi ,

why sap stored BSEG table as cluster table ,

is there any specific reason .

plz tell me if any body knows ,

thanks in advance ,

regards ,

srinivas

Re: Doubt on BSEG table

ThomasZloch — Wed, 11 Jun 2008 10:45:31 GMT

BSEG is already around since early R/3 days (probably R/2). I guess SAP rightly assumed that it's gonna a be big one in many installations and decided to store it as a cluster table, which is more space efficient than a transparent table. Same with e.g. table CDPOS.

Of course we all know the drawbacks, no joins possible, no secondary index, no data adjusting after table changes.

Let's wait for a more profound answer.

Greetings

Thomas

Re: Doubt on BSEG table

Former Member — Wed, 11 Jun 2008 10:50:20 GMT

hii

see this article

http://blogs.ittoolbox.com/sap/db2/archives/select-from-bsegrfblg-performance-problem-14247

read last paragraph.i hope you will get your answer

thx

twinkal

Re: Doubt on BSEG table

Former Member — Wed, 11 Jun 2008 10:52:59 GMT

\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]

Edited by: Jan Stallkamp on Jun 11, 2008 1:16 PM

Re: Doubt on BSEG table

JanStallkamp — Wed, 11 Jun 2008 11:12:03 GMT

Hi.

No double postings please! You have asked the same question only 15 minutes before this one.

I will lock the thread.

Best regards,

Jan Stallkamp

Re: Doubt on BSEG table

JanStallkamp — Wed, 11 Jun 2008 11:17:30 GMT

Hi.

Don't copy and paste material from other people into the forums if you are not the owner of it. Continuing with this might result in your account being deleted permanently.

Best regards,

Jan Stallkamp