Answer Posted / tdguy
If a table in a database either has no natural key or the
natural key is so long that using it as the key would be
inefficient then we need to consider using a pseudokey
instead. Pseudokeys are usually given the same name as the
table they belong to with _id added to the end of the name.
They usually are defined to contain a number and use
autoincrement in mySQL or the equivalent in other versions
of SQL to dynamically allocate a value when new rows are
created.
source: http://www.felgall.com/mysql04.htm
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between union and union all in teradata?
List out all forms of LOCKS that are available in Teradata.
What are the different functions performed in development phase?
Different phases of multiload?
What exactly do you know about catching in teradata?
Can we collect statistics on table level?
What are the functions involved in shared information architecture?
What is collect statistics?
What is node? How many nodes and amps used in your previous project?
What is a three-tier data warehouse?
How is MLOAD Teradata Server restarted after execution?
What is meant by a Parsing Engine?
What are the joins in teradata?
What is the syntax for case when statement?
Why is the case expression used in teradata?
