Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 .

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


Please Help Members By Posting Answers For Below Questions

Explain PDE.

1076


How do you set the session mode parameters in bteq?

1102


What do you mean by teradata intelliflex?

1089


How to eliminate product joins in a teradata sql query?

1021


Explain the most common data types used in teradata?

1064


What do you mean by ttu in teradata?

1031


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 ?

2474


What is a node in teradata?

994


What is basic teradata query language?

1111


What is oltp?

973


What can be achieved by using the teradata rdbms?

1032


Highlight the limitations of TPUMP Utility.

1111


Explain the term 'row' related to relational database management system?

949


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1774


What do you mean by teradata sql assistant?

1057