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 are the design features involved in teradata?
Explain amp in teradata?
Which is more efficient group by or distinct to find duplicates?
What is the purpose of indexes?
What do you mean by teradata sql assistant?
What is stored procedure in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How can bottlenecks be identified?
How you will check the version of teradata?
What is difference between user and database in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is the purpose of using case expression in teradata?
What are the different functions included in the server software?
how can we analyze the locks ?
During the Display time, how is the sequence generated by Teradata?
