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 / guru

ONE LINE ANSWER: INdexing acts as SET option (Where clause)
while an query is being executed provided the query
contains these indexes.


Guru,
Advanced Teradata Certified Professional

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions performed by bynet?

1039


What is bteq utility in teradata?

963


What is teradata? Also, list out some of the primary characteristics of teradata.

1054


What are the various indexes in teradata? Why are they preferred?

1001


How would you load a very large file in teradata in general?

1032


What tools would you use for that?

1107


Explain fastload in teradata?

1100


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1041


What are tpump utility limitations?

1118


Describe the between keyword in teradata?

1036


Explain amp in teradata?

1076


Describe primary index in teradata?

1000


What is primary index and secondary index?

1027


What do you mean by teradata intellicloud?

1032


What is multi insert?

1045