Interested to Buy Any Domain ? << Click Here >> for more details...
What is a pseudo key? What is its use???
- 2 Answers
- 19026 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
it is used in locks the rowhash
best to tell EXPLAIN in this explanation we locks pseudo key
then it start
| Is This Answer Correct ? | 0 Yes | 10 No |
What is use of compress in terdata?Explain?
What does sleep function does in fast load?
If table have access lock.In the same table write lock is posible or not?
What exactly do you know about catching in teradata?
What do you mean by fastexport in teradata?
any one pls tell me what are the table names in banking project?
If RDBMS is halted what will you do ?
what is meant by Hot amp?
Explain the term 'tables' related to relational database management system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
0 Answers Infosys, Wells Fargo,
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Explain the advantages of partitioned primary index in a query?
Teradata 
