摘要 |
A multi-table query system utilizes indexes to provide filtering and then obtains the desired data. The multi-table query system reduces excessive data retrieval by minimizing access by multi-table joins to data pages until absolutely necessary in a process of executing the query. The multi-table query system improves runtime performance and minimizes a risk of poor performance if the optimizer of the DBMS incorrectly estimates the filtering and chooses a less than optimal table join sequence. The multi-table query system does not require the implementation of any additional indexing technology for the DBMS. Existing indexing technologies, such as the standard single table B-tree index design can exploit the multi-table query system.
|