Difference between revisions of "INDEX"
Jump to navigation
Jump to search
(Created page with "An INDEX is a performance tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed column. By default, Oracl...") |
(No difference)
|
Revision as of 23:20, 14 November 2017
An INDEX is a performance tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed column. By default, Oracle creates B-Tree indexes.
CREATE INDEX customer_idx ON customer(city)