Answer Posted / deepa

A table can have any number of indexes. However, the more indexes there are, the more overhead is incurred as the table is modified. Specifically, when rows are inserted or deleted, all indexes on the table must be updated as well. Also, when a column is updated, all indexes that contain the column must be updated.

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2266

---

What is sql keyword?

1006

---

explain about mysql and its features. : Sql dba

1018

---

How to test for null values?

1056

---

What is sql indexing?

1013

---

What packages are available to pl/sql developers?

1064

---

What is inner join in sql?

1084

---

Is subquery faster than join?

1017

---

What information is needed to connect sql*plus an oracle server?

1030

---

What is sql and its types?

1192

---

What is meaning of <> in sql?

1070

---

Does sap use sql?

996

---

What is nvarchar in sql?

927

---

What are the limitations of sql express?

1071

---

Which software is used for pl sql programming?

993

---