Question

What is query optimization and process in dbms?

Answer 1

Query optimization is a function of many relational database management systems. The queryoptimizer attempts to determine the most efficient way to execute a givenquery by considering the possiblequery plans. ... However, some database engines allow guiding thequery optimizer with hints.

Answer 2

$\green{ \fcolorbox{grey}{grey}{ \checkmark \: \textsf{Verified \: answer}}}$

Features of DBMS

• ⟹ Structure: Where data is structured in hierarchical form in a DBMS, data is structured in tabular form in a RDBMS.
• ⟹ User capacity: A RDBMS is capable of operating with multiple users. DBMS can only manage one user at a time.
• ⟹ Software/hardware requirements: A RDBMS has greater software and hardware requirements.
• ⟹ Data capacity: A DBMS is capable of managing small amounts of data and a RDBMS can manage an unlimited amount of data.