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 the difference between left outer join and left join?
What is scalar function?
Can we use more than one null value for unique key?
31 Answers A1 Technology, Wipro,
Explain the types of joins in sql?
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
Which is the best place to learn hadoop?
Explain the select statement in sql?
i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.
What is oracle and pl sql?
What is the use of index in hive?
Is primary key a clustered index?
What do you mean by rowid?
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)