Tuesday, November 14, 2017

Understanding MongoDB explain()

DZone Database Zone
Understanding MongoDB explain()
Understanding MongoDB explain()

For almost all SQL statements, there will be more than one way for Oracle to retrieve the rows required. When Oracle parses an SQL statement, it must decide which approach will be fastest. The process of determining this “optimal” path to the data is referred to as query optimization.

Basics of Query Optimization

For instance, consider the following query:

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...