Answer / suman

what is indexing
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

what is a database? : Sql dba

0 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

Why query optimization is needed?

0 Answers  

---

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

0 Answers  

---

How do you sort in sql?

0 Answers  

---

what are set operators in sql? : Sql dba

0 Answers  

---

What is query execution plan in sql?

0 Answers  

---