In general, how do you optimze any sql in teradata?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,


which option is used to restart the fastexport script ?

2 Answers   TCS,


what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,


What are tpump utility limitations?

0 Answers  


Highlight the points of differences between the database and user in Teradata.

0 Answers  






If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  


Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,


suppose one Cylinder split data blocks are moved from where?

1 Answers  


Highlight the need for Performance Tuning.

0 Answers  


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


what is the difference between bpo and call centre?

2 Answers   American Solutions,


Why does varchar occupy 2 extra bytes?

0 Answers  


Categories