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 |
How do you declare a constant?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
What is a memo field?
What is sql entity?
what are the disadvantages of mysql? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
How to return multiple records from procedure?
How to start the command-line sql*plus?
If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?
How can I get the number of records affected by a stored procedure?
What is a function in oracle pl sql?
Does sqlite need a server?
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)