When a Condition in the WHERE Clause of a Query

question 48

Short Answer

When a condition in the WHERE clause of a query references a column that has been indexed,the DBMS performs an operation known as ____________________ to determine if the index can be used.

---

Definitions:

Tax

Compulsory financial charges or some other type of levy imposed upon a taxpayer by a governmental organization in order to fund government spending and various public expenditures.

Price Ceiling

A Price Ceiling is a government-imposed limit on how high a price can be charged for a product, intended to protect consumers from exorbitant prices.

Supply Curve

A graph showing the relationship between the quantity of a good that producers are willing to sell and the price of the good.

Gasoline

A petroleum-derived flammable liquid primarily used as fuel in internal combustion engines.