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 |
i have some prob lem to tell me about my self in interview first round ...
write a query to delete similar records in different tables with same structure
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
Which one is better subquery or joins?
Can you have multiple SPs with the same name on a database?
In what condition is it good to disable a trigger?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is data manipulation language?
What is a crud api?
How do I create a sql script?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Is join same as left join?
Oracle (3253)
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)