how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
Answer Posted / gowthami
hIIIIIII.........
BY using indexes and collect statistics we can increase the
query performance
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why does varchar occupy 2 extra bytes?
What is meant by a Least Cost Plan?
What is the use of having index on table?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is inner join and outer join?
What is the difference between teradata and basic rdbms?
Explain the term 'tables' related to relational database management system?
Can you connect multiload from ab initio?
What are teradata utilities?
What are the updated features of teradata?
How to eliminate product joins in a teradata sql query?
What is dimensional modeling?
What do high confidence, low confidence and no confidence mean in explain plan?
What do you mean by tpt in teradata?
What is the difference between fastload and multiload?