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

How to Extract data from multiple legacy systems?

1040


Which is faster fastload or multiload?

1041


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

1115


Which is more efficient group by or distinct to find duplicates?

1034


What is the purpose of upsert command?

1077


What do you mean by teradata intelliflex?

1035


What are types of partition primary index (ppi) in teradata?

998


What is a node in teradata?

935


Explain the term 'columns' related to relational database management system?

987


Explain fallback in teradata?

984


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723


What is a dimension table?

981


What is meant by a Highest Cost Plan?

988


List the logical and conditional operators that are used with teradata along with their meanings?

938


Explain BYNET.

947