1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / huma

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / suresh babu

Nothing will happen,until you alter the index column

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Does view store data in sql?

0 Answers  

What is cascade in sql?

0 Answers  

how can i read write files from pl/sql

3 Answers  

What is pl/sql table? Why it is used?

0 Answers  

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  




What does cursor do in sql?

0 Answers  

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

Is natural join same as inner join?

0 Answers  

What is extent clause in table space?

1 Answers   TCS,

What are the different sql languages?

0 Answers  

What is left inner join in sql?

0 Answers  

What are transaction and its controls?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories