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

What are the functions involved in shared information architecture?

1084


What is the primary index in teradata?

1219


How can bottlenecks be identified?

1029


What tools would you use for that?

1122


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

999


How to run a query in teradata?

1098


Describe the between keyword in teradata?

1048


What is TPD?

1384


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1034


If RDBMS is halted what will you do ?

2182


What is oltp?

986


What are the uses of client software involved in teradata?

995


Can you fastexport a field, which is primary key by putting equality on that key?

1191


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

4387


What are the different functions included in the server software?

1049