How do you optimize transactions for good system performance? - MSF

How do you optimize transactions for good system performance?

The performance increases on optimizing transactions because:

1. An optimized query targets the exact field data are needed. So the unnecessary fields are not fetched.
2. Use of distinct command removes duplicate or redundant data without changing the actual data.
Impact of indexing on data access - microsoft solution framework
Databases indexes are used to improve the speed of operations on database tables. Indexes are created using one or more fields of a table........
Difference between horizontal and vertical partitioning of data - microsoft solution framework
Horizontal partitioning of data refers to storing different rows into different tables. E.g.: Students with their first name starting from A-M are stored in table A........
Benefits of using components to implement business rules - microsoft solution framework
Microsoft solution framework - What are the benefits of using components to implement business rules?.........
Post your comment