Can I read Physical Database Design and Tuning on EtoBox?

Physical Database Design and Tuning by Sandeep Kumar Sai is a document available to read on EtoBox.

What is Physical Database Design and Tuning about?

The document discusses physical database design and tuning. It begins by explaining that physical design is tightly linked to query optimization and that understanding the workload is important. Some key decisions include choosing appropriate indexes based on the most important queries, considering the impact on updates, and potentially making changes to the conceptual schema like horizontal partitioning. Guidelines are provided for index selection, query tuning, and avoiding unnecessary intermediate relati

Author

Sandeep Kumar Sai

Language

EN