topic ddic doubts in Application Development and Automation Discussions

ddic doubts

Former Member — Wed, 18 Jul 2007 05:59:51 GMT

hai guru's,

in creating database tables, in real time which delivery class we have to

give .

in technical settings we give authorization group as &nc& why? this.

where we use indexes , that we are created at ddic level.

Re: ddic doubts

Former Member — Wed, 18 Jul 2007 06:05:09 GMT

We use A( application tables) or C (for customization )tables as delivery class in real time.

In technical settings we use Data class and size category

where as while creating Table maintenance generator we give auth group as &NC& this is a system default, instead of creating our own and using we use this.

Indexes are useful while fetching data using select statements

We use those fields(for which we create index) in the WHERE CONDITION of the select statement so that the data is fetched fastly

<b>Reward points for useful Answers</b>

Regards

Anji

Re: ddic doubts

Former Member — Wed, 18 Jul 2007 06:10:41 GMT

Hi,

1. Most of the time we dealt with A, as it is the delivery class used for the tables which will be frequently modified later when in use.

2.&nc& suggests that it is not belong to any authorisation group. The authorization group allows extended authorization protection for particular objects.

3.If we are selecting from a particular table more frequently, we can create indexes for the table which will enable the select more faster.

<b>Please reward all helpfull answers</b>

Regards,

Rakesh.