Doubt on BSEG table

[Former Member]

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

[Former Member]

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

[ThomasZloch]

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

[Former Member]

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

[Former Member]

\[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

[JanStallkamp]

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

[JanStallkamp]

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