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


Please Help Members By Posting Answers For Below Questions

What is the use of teradata system software?

547


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1893


How do you define Teradata?

605


Explain BYNET.

604


How many codd's rules are satisfied by teradata database?

660






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

547


What are the string manipulation operators and functions associated with teradata?

634


When tpump is used instead of multiload?

629


What is partitioned primary index (ppi)?

566


What can be achieved by using the teradata rdbms?

622


What is the purpose of joins in teradata?

540


what is sysdba and sysdbc ? which has high priority ?

3369


What do you mean by tpt in teradata?

588


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1958


Can you connect multiload from ab initio?

640