Techniques employed to tune operational performance

Question

Demonstrate some of the techniques which can be employed to tune operational performance?

Answer 1

Selecting primary and secondary keys can raise the speed of row selection, ordering, and row joining. Selecting the suitable file organization for base tables and indexes can also enhance performance. Clustering related rows together and maintaining statistics about tables and indexes can lead to raised efficiency.