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

Can instead of triggers be used to fire once for each statement on a view?

962

---

What is the starting oracle error number?

1054

---

What is the use of index in sql?

1017

---

What is record variable?

989

---

What does count (*) mean?

929

---

What port does sql server use?

1061

---

What is normalization in a database?

1156

---

What are different joins used in sql?

1056

---

How to fetch alternate records from a table?

1244

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1042

---

Can you selectively load only those records that you need? : aql loader

1048

---

what is union? : Sql dba

1027

---

What are the different parts of a package?

1115

---

What is string join?

977

---

Is sql a backend?

1021

---