Interested to Buy Any Domain ? << Click Here >> for more details...
What EXPLAIN does in Teradata, what is High confidence, Low
confidence and No confidence.. And How we improve the query
performance .
- 5 Answers
- 34484 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / farooq
HIGH CONFIDENCE:Statistics are collected up to date.
LOW CONFIDENCE:Statistics are not up todate.
NO CONFIDENCE:Statistics are not collected.
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
Discuss the advantages of using partitioned primary index in a query?
Can we collect statistics on multiple columns?
What are the multiload utility limitations?
How many codd's rules are satisfied by teradata database?
What is meant by a Least Cost Plan?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is the use of having index on table?
In BTEQ, how are the session-mode parameters being set?
What is dimensional modeling?
Did you write stored procedures in teradata?
Explain BYNET.
What is real time and near real time data warehousing?
What are the design features involved in teradata?
Why teradata is used?
What are the available primary index types in teradata.
