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...

What is Join Index in TD and How it works?

Answer Posted / yuvaevergreen

Join index stores the joined rows to two or more tables in
the permanent space. Not beneficiary always. Space
consumptions may be a problem. Can be used whenever large
tables are consistently and frequently joined and space may
not be a problem.

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3568


How does hashing happens in teradata?

1048


What are the steps involved after the disk manager passes the request?

1062


What is teradata?

1088


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

2429


What is teradata and why it is used?

1047


Highlight the need for Performance Tuning.

1060


What is a three-tier data warehouse?

1071


What are tpump utility limitations?

1088


How to view every column and the columns contained in indexes in teradata?

1004


What is upsert statement in teradata?

1076


Give the sizes of SMALLINT, BYTEINT and INTEGER.

1125


What is inner join and outer join?

1064


What are different table types used in teradata?

1003


Why does varchar occupy 2 extra bytes?

1137