how can we analyze the locks ?
No Answer is Posted For this Question
Be the First to Post Answer
The transaction exceeded the maximum number of rowhash locks allowed
what is the difference between primary index and secondary index?.
What is oltp?
Explain fallback in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What are the components used in smp and massively parallel processing (mpp) machines?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Explain fastload in teradata?
What is teradata?
What is meant by a Least Cost Plan?