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 does Amp contain and what are all the operations that it performs?

1006


What are default access rights in teradata?

1124


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1080


Highlight the need for Performance Tuning.

1105


What is a node in teradata?

999


How do you define Teradata?

1037


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

4373


During the Display time, how is the sequence generated by Teradata?

1055


How can bottlenecks be identified?

1018


What are the joins in teradata and how many types of joins are there in teradata?

1004


When tpump is used instead of multiload?

1105


What are the components used in smp and massively parallel processing (mpp) machines?

1057


what are the uses of fact table and dimension table in banking project?

4556


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2419


How is MLOAD Teradata Server restarted after execution?

1267