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 bitemporal narrowing?

1370

What is a database trigger?

1133

How do I make sql search faster?

1044

How can we implement rollback or commit statement in a trigger?

1084

What is sqlite used for?

1048

What are the 3 types of behavioral triggers?

1312

Can variables be used in sql statements?

1073

Write a query to find the names of users that begin with "um" in sql?

1044

What is rank dense_rank and partition in sql?

1085

What is data types in sql?

1070

What is the difference between an inner join and an outer join?

1081

What does the base_object_type column shows in the user.triggers data dictionary view?

1096

What is assignment operator in pl sql?

1086

Can I learn sql in a week?

1119

How do you delete duplicates in sql query using rowid?

989