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 many types of primary keys are there?

1043

---

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

1064

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1230

---

Advantages and disadvantages of stored procedure?

1126

---

How to use transactions efficiently : transact sql

1063

---

What are analytical functions in sql?

1038

---

What are sql queries used for?

1033

---

What is replication id?

941

---

Is pl sql a scripting language?

1038

---

How do I run a sql query in pgadmin 4?

968

---

What is sql engine in oracle?

998

---

What are the types of join in sql?

1109

---

Can we enter data in a table in design view?

974

---

What is the execution plan in sql?

1035

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1093

---