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...

How does indexing improve query performance?

Answer Posted / yuvaevergreen

PI is very important in TD, because the data distribution
is basically dependent on PI.
1.Data distribution
2.Fastest way to retrieve rows
3.Important for joins

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the term 'primary key' related to relational database management system?

1031


How do you set the session mode parameters in bteq?

1102


What is oltp?

974


How many types of joins are there in teradata?

973


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4369


Explain teradata utilities. What is multiload, fast load, tpump?

1007


How do you determine the number of sessions?

1059


Explain the types of join supports by teradata?

991


How is the teradata different from oracle?

1099


What is meant by a node?

1039


Explain teradata architecture?

1089


Explain Teradata performance tuning and optimization?

1159


What is inner join and outer join?

1108


How to eliminate product joins in a teradata sql query?

1023


What is the meaning of Caching in Teradata?

1136