What is a pseudo key? What is its use???
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 the multi-insert?
Explain about Skew Factor?
List out all forms of LOCKS that are available in Teradata.
List the logical and conditional operators that are used with teradata along with their meanings?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
why should we go Teradata over Oracle,what is the main differences?
What do you mean by tpt in teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Explain amp in teradata?
Describe primary index in teradata. And what are the available primary index types?
Explain the term 'primary key' related to relational database management system?