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

Why triggers are used?

968

What is sqlca in db2?

936

Can we call a function containing dml statements in a select query?

960

what is union, minus and interact commands? : Sql dba

1168

how to use case expression? : Sql dba

999

Define overloaded procedure?

1059

How many triggers can be applied to a table?

1039

Can unique keys be null?

882

Explain the difference between rename and alias?

1003

What is java sql package?

1072

Is id a reserved word in sql?

1133

How can I change database name in sql?

1050

Explain what is rdbms?

1017

Can we use pl sql in mysql?

996

how to check server status with 'mysqladmin'? : Sql dba

1053