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.

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

wat is global index and local indes

1 Answers   Oracle,

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---