Answer / Vikas Gautam

Partitioning and indexing are both database organization techniques, but they serve different purposes. Partitioning divides a table into smaller parts based on some criteria (e.g., date range or value range). Indexing creates a separate data structure that maps values within a column or columns to their corresponding physical locations in a table, improving query performance by reducing the amount of data scanned. In other words, partitioning is used for organization and query optimization, while indexing is used specifically for faster query execution.

What are analytical functions in sql?

1 Answers  

---

Is sql developer case sensitive?

1 Answers  

---

What is java sql driver?

1 Answers  

---

Why commit is not used in triggers?

1 Answers  

---

what is ref cursor in pl/sql?

3 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

1 Answers  

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1 Answers  

---

What are the advantages of normalization?

1 Answers  

---

What is trigger price?

1 Answers  

---

Which one is better sql or oracle?

1 Answers  

---

what is rollback? : Sql dba

1 Answers  

---

can sql servers linked to other servers like oracle? : Sql dba

1 Answers  

---