Explore >> Select a destination
|
You are here 
|
www.dbaglobe.com | ||
| | | | |
sookocheff.com
|
|
| | | | | Title and Author of Paper Access Path Selection in a Relational Database Management System. P. G. Selinger et al. Summary This paper describes methods of the SQL query optimizer for determining the cost of satisfying a query. It also describes methods for choosing among several competing methods. What are the motivations for this work? SQL is a high-level language where requests for data are stated non-procedurally. The user is not expected to need any knowledge of how the data is stored in the database or how it is retrieved. Thus, it is up to the DBMS to choose an appropriate access path for data retrieval on the users behalf. By designing the database in this fashion, we preserve data independence, where a users view of the data is independent of the data... | |
| | | | |
antognini.ch
|
|
| | | | | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | I've discussed the capabilities of the dbms_xplan package in a couple of posts already; and shown how useful it can be in two examples: understanding a problem with filter subquery selectivity and understanding why some Cartesian merge joins were appearing unexpectedly. Let me make a crucial point about execution plans (again): if you have a... | |
| | | | |
maryjob.com
|
|
| | | https://docs.google.com/presentation/d/13I2iABHqayIkRIY1h5Dadc9lsLfKVv9IApm0zSYDT7g/edit?usp=sharing | ||
