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...") |
|||
| Line 2: | Line 2: | ||
CREATE INDEX customer_idx ON customer(city) | CREATE INDEX customer_idx ON customer(city) | ||
DROP INDEX indexname | |||
ALTER INDEX indexname RENAME TO new_name | |||
[[#Rules for Character Strings Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Rules for Character Strings Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Latest revision as of 23:29, 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)
DROP INDEX indexname
ALTER INDEX indexname RENAME TO new_name