Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

write a query to delete similar records in different tables with same structure

4 Answers  

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

Which one is better subquery or joins?

0 Answers  

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

In what condition is it good to disable a trigger?

0 Answers  

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

What is data manipulation language?

0 Answers  

What is a crud api?

0 Answers  

How do I create a sql script?

0 Answers  

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

Is join same as left join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories