What is Join Index in TD and How it works?

Answer Posted / kiran

It is an indexing structure containing columns from one or
more base tables.
supose one query frequently request a perticular join on
multiple tables that is recomdable.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the newly developed features of Teradata?

818


What are default access rights in teradata?

883


Comment whether bottleneck is an error or not.

877


How you will check the version of teradata?

884


What are the different functions performed in development phase?

868


Describe primary index in teradata. And what are the available primary index types?

779


What are the different softwares used with their functions in teradata?

815


Why are oltp database designs not generally a good idea for a data warehouse?

843


How do you create tables? Exact syntax, and create profiles, users in teradata?

812


How do you do backup and recovery in teradata?

829


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

873


What are the different table types supported by teradata?

761


what is sysdba and sysdbc ? which has high priority ?

3615


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

790


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1854