How Do You Optimize Transactions For Good System Performance?

1.	How Do You Optimize Transactions For Good System Performance?
Answer» The performance INCREASES on optimizing transactions because: An optimized QUERY targets the exact field data are needed. So the unnecessary FIELDS are not fetched. USE of distinct command removes duplicate or redundant data WITHOUT changing the actual data. The performance increases on optimizing transactions because:

Answer»

The performance INCREASES on optimizing transactions because:

An optimized QUERY targets the exact field data are needed. So the unnecessary FIELDS are not fetched.
USE of distinct command removes duplicate or redundant data WITHOUT changing the actual data.

The performance increases on optimizing transactions because:

Discussion