Base table with extension columns Extension

Explain when we use the following scenario's:Base table having extension columns Extension, table have extension columns Which one do you prefer, Explain?

Interview Candidate
Jul 31st, 2005
3
5201

Scenarios

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

aravind

Oct 28th, 2005

First preference will be for base table's extension column. if your database table space doesn't allow it then you can go for extensiontable's extension column.

Kamal

Nov 2nd, 2005

In Siebel 7.8 there is no restriction in the number of columns in tables, but depending on the frequency of use and the relationship you should use it discretely (when 1:1 relation is there).
And when you say extension columns are they Siebel extension or custom extension??

SiebelguyIndy
Profile Answers by SiebelguyIndy

Sep 30th, 2010

If you are refering to whether you should extend a base table or extension table, it is always preferable to extend the base table. This should only be done after exhausting the use of the many extension columns provided by Siebel OTB. The reason for this is related the the number of joins needed to select the extention table and subsequent extention columns, which will have an impact on performance if there are a large number of records in the table.