CodesJava

Easy learning with example program codes

What are Indexes in SQL?


An index represents a schema object that contains an entry for each value that appears in the indexed column(s) of the table or cluster and provides direct, fast access to rows.

Syntax

CREATE INDEX index_name
ON table_name (column_name)

Related topics

Posted in SQL   
Sign Up/ Sign In
Ask a Question


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki