Interested to Buy Any Domain ? << Click Here >> for more details...
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
Difference between multiload and tpump?
What do you mean by parsing?
What are the various etl tools in the market?
What is the purpose of using case expression in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the things to be considered while creating secondary index?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is spool space? Why do you get spool space errors?
What is smp and mpp platforms?
What are the updated features of teradata?
What interface is used to connect to windows based applications?
Name the five phases that come under MultiLoad Utility.
What are the various indexes in teradata? How to use them? Why are they preferred?
How many codd's rules are satisfied by teradata database?
What is database exceptions in teradata?
