hIIIIIII......... BY using indexes and collect statistics we can increase

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

Question Posted / gowthami

Answer Posted / gowthami

hIIIIIII.........
BY using indexes and collect statistics we can increase the
query performance

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of having index on table?

1008

What are the different functions included in the server software?

1046

In the Primary Index, what is the score of AMPs that are actively involved?

1083

How is MLOAD Teradata Server restarted after execution?

1275

What are the primary characteristics of the Teradata.

1167

How can we check the version of Teradata that we are using currently?

1076

Explain the advantages of partitioned primary index in a query?

1034

What are the steps involved in the process flow of the sql statement through channel attached system?

1120

What is the multi-insert?

1045

What are the various etl tools in the market?

1078

how can we analyze the locks ?

2138

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1113

Highlight the differences between Primary Key and Primary Index.

1099

What is partitioned primary index (ppi)?

1056

Explain fallback in teradata?

1071