Answer Posted / rajnish chauhan

Follow the steps for performance SQL Tunning.
1) First of all tables structure should be in normalization form.
2) Then Index and tables Statistics should be upto date.
3) make it different tables table space for tables and index.
4) Avoid unnecessary joins from the query.
5) Avoid Full Table Scan and Index Skip scan.if query fetching less then 15% records from the table then index scan faster then FTS.and FTS is better then index scan if tables consist larg no of data because Index scan read multiple time on each row where as FTS read single time for each row.
6)monitor Plan through Explain plan or TKPROFF.
7)Table ordering also improve the performance of the query like.Master table should take first place then after Transaction table.
8) Check index path used or not in explain plan .if not then check weather index enable or not.then use Index Hint to forcefully used.
9)Avoid function on index column.
10) other small things you can apply like use Having instead of Where clause , use Exists then IN , use Substring instead of <> caluse.

Thanks

how to check server status with 'mysqladmin'? : Sql dba

1134

---

How do you run a query?

1051

---

What is sql in java?

1134

---

Why we use joins in sql?

1036

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4099

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1105

---

Is keyword pl sql?

1057

---

what is msql? : Sql dba

1044

---

What is a natural join sql?

1040

---

What is scalar function in sql?

1100

---

How show all rows in sql?

1060

---

Can a commit statement be executed as part of a trigger?

1105

---

What is $$ in sql?

1046

---

What is pl sql architecture?

1006

---

What is having clause in sql?

1018

---