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
  • 5
  • 5096

  
Showing Answers 1 - 5 of 5 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. 

  Was this answer useful?  Yes

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??

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions