how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
- 2 Answers
- 6058 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
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What are the available primary index types?
Highlight all the modes that are present under Confidence Level.
What is meant by a Least Cost Plan?
What are teradata utilities?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How is MLOAD Teradata Server restarted after execution?
What is primary index and secondary index?
What are tpump utility limitations?
What is the maximum number of dml can be coded in a multiload script?
Highlight the differences between Primary Key and Primary Index.
What do you mean by ttu in teradata?
Explain vproc in teradata?
How to find duplicates in a table?
How many sessions of MAX is PE capable of handling at a particular time?
