A query is called covered query if satisfies the following two conditions:
- The fields used in the query are part of an index used in the query.
- The fields returned in the results are in the same index.
You May Also Like
Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
- Interview
- November 30, 2023
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
- Interview
- November 30, 2023
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...
- Interview
- November 30, 2023
