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 is oltp?

937


What is database exceptions in teradata?

914


Mention a few of the ETL tools that come under Teradata.

1039


What is the maximum number of dml can be coded in a multiload script?

1072


What are the primary characteristics of the Teradata.

1085


Write a program to show the parser component used in teradata?

945


What are the various etl tools in the market?

1036


What are the different table types supported by teradata?

914


any one answer me how they can analyzing the project using data ware housing?

2429


what is object level locking ? where do appear this type of locking ?

3456


What are the various reporting tools in the market?

1008


What do you mean by tpt in teradata?

979


What is the command in bteq to check for session settings ?

1139


In Teradata, what is the significance of UPSERT command?

1164


What are the available primary index types?

1170