Autonumber function

[prabhas277]

Hi experts,

How to optimized the  script by using autonumber function in script level? and If we use the link table then what it will be( star schema or snowflake) ..explain?

Regards,

prabhas

[robert_mika]

When you need to use composite key to link tables  by concatenation many other keys.

Your key maybe very long so you can use Auto-number to replace this string with a number and your information will be still kept.

Depends on model but usual that will be star schema