Interested to Buy Any Domain ? << Click Here >> for more details...
wat is global index and local indes
- 1 Answers
- 5468 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / nikhil
Global Index: A global index is a one-to-many relationship,
allowing one index partition to map to many table
partitions. A global index can only be a range partition!
Local Index: A local index is a one-to-one mapping between a
index partition and a table partition. In general, local
indexes allow for a cleaner “divide and conquer” approach
for generating fast SQL execution plans with partition pruning.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How to make a replica of existing oracle server to another server?
what is asm?
How would you force a log switch?
Name a tablespace automatically created when you create a database.
What is the importance of a recovery model? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is fill factor? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???
How would you determine the time zone under which a database was operating?
Why would you call update statistics? : sql server DBA
-
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)
