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 |
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
What is upsert statement in teradata?
How many codd's rules are satisfied by teradata database?
Fast Load Script is failed and error tables are available then how do you restart?
Comment whether bottleneck is an error or not.
Which is faster fastload or multiload?
What is a pseudo key? What is its use???
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
What are the things to be considered while creating secondary index?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the string manipulation operators and functions associated with teradata?