Discuss Some Of The Techniques That Can Be Used To Tune Operational P

1.	Discuss Some Of The Techniques That Can Be Used To Tune Operational Performance?
Answer» Choosing primary and secondary keys can increase the speed of ROW SELECTION, JOINING, and row ordering. Selecting the appropriate file organization for base tables and INDEXES can also improve performance. Clustering related rows together and maintaining statistics about tables and indexes can lead to increased EFFICIENCY. Choosing primary and secondary keys can increase the speed of row selection, joining, and row ordering. Selecting the appropriate file organization for base tables and indexes can also improve performance. Clustering related rows together and maintaining statistics about tables and indexes can lead to increased efficiency.

Discuss Some Of The Techniques That Can Be Used To Tune Operational Performance?

Answer»

Choosing primary and secondary keys can increase the speed of ROW SELECTION, JOINING, and row ordering. Selecting the appropriate file organization for base tables and INDEXES can also improve performance. Clustering related rows together and maintaining statistics about tables and indexes can lead to increased EFFICIENCY.

Choosing primary and secondary keys can increase the speed of row selection, joining, and row ordering. Selecting the appropriate file organization for base tables and indexes can also improve performance. Clustering related rows together and maintaining statistics about tables and indexes can lead to increased efficiency.

Discussion

No Comment Found

Related InterviewSolutions

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?