If the base table structure is changed what will happen to
join index????
Answers were Sorted based on User's Feedback
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 |
Answer / suresh babu
Nothing will happen,until you alter the index column
| Is This Answer Correct ? | 0 Yes | 0 No |
What is sql exception?
Does view contain data?
how to drop an existing table in mysql? : Sql dba
explain mysql aggregate functions. : Sql dba
How to place comments in pl/sql?
Where not exists in sql?
What is fmtonly in sql?
Can we use delete in merge statement?
How do I count rows in sql?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
Can we commit inside a trigger?
What is a transaction?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)