Interested to Buy Any Domain ? << Click Here >> for more details...
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 6677 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain and compare pros and cons of snow flake schemas?
What is inner join and outer join?
What are the functions of a teradata dba?
What are the multiload utility limitations?
What are the available primary index types?
Define views in teradata with syntax.
What are the design features involved in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the different methods ot loading a dimension table? A fact table etc?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Highlight all the modes that are present under Confidence Level.
What is meant by a node?
Can you connect multiload from ab initio?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
How is the teradata different from oracle?
