SQL (Structured Query Language) Question:

What is SQL Indexes?

Tweet Share WhatsApp

Answer:

Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tradeoff is query speed vs. update speed. Oracle automatically update indexes. Concatenated index max. is 16 columns.

Download SQL PDF Read All 172 SQL Questions
Previous QuestionNext Question
What is sql Intersect?What are SQL Data types?