1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

What is Index?

Discussion in 'Databases - MySQL, SQL, Oracle, Access and others' started by websky19, Jun 14, 2017.

  1. websky19

    websky19 Active Member Registered

    Credit:
    0.64311-BRO
    Hi,

    An index is a physical structure containing pointers to the data. Indices are created in an existing table to locate rows more quickly and efficiently. It is possible to create an index on one or more columns of a table, and each index is given a name. The users cannot see the indexes; they are just used to speed up queries. Effective indexes are one of the best ways to improve performance in a database application. A table scan happens when there is no index available to help a query. In a table scan SQL Server examines every row in the table to satisfy the query results. Table scans are sometimes unavoidable, but on large tables, scans have a terrific impact on performance.
     
    kitsun3 likes this.
  2. Ovi

    Ovi Well-Known Member Registered Active Member

    Credit:
    1.32640-BRO
    Indexing is the process of creating indexed for record collection. A database index is a data structure that improve the speed of data retrieval operation on a database table.
     
    Vendeta21 likes this.

Share This Page

Loading...