Join index will not affected until we change the column name or data type

If the base table structure is changed what will happen to
join index????

Question Posted / mubarish

Answer Posted / mubarish

Join index will not affected until we change the column name
or data type of the column which we have used in join condition.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is replication id?

941

Where is sql database stored?

985

Write a sql query to find the names of employees that begin with ‘a’?

1015

What are different sql data types?

1051

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1074

What is an intersect?

1108

What are three advantages to using sql?

1024

Explain two easy sql optimizations.

1016

what tools available for managing mysql server? : Sql dba

1087

what is auto increment? : Sql dba

1014

What will you get by the cursor attribute sql%found?

965

What is synonyms?

1059

Explain the significance of the & and && operators in pl sql.

1009

how to convert character strings to numeric values? : Sql dba

1112

What is the difference between function and procedure in pl/sql?

1090