Results 1 to 5 of 5
  1. #1
    Registered User
    Join Date
    Jan 2019
    Location
    Jaipur
    Posts
    10

    Indexes in SQL ?

    Hello Dear,

    Please Tell Me What are Indexes in SQL ?

  2. #2
    Registered User
    Join Date
    Oct 2016
    Posts
    188
    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 columns. Each index name must be unique in the database.

  3. #3
    Registered User
    Join Date
    Mar 2019
    Location
    Ahmedabad
    Posts
    180
    Indexes are special lookup tables that the database search engine can use to speed up data retrieval.
    • An index is used to speed up searching in the database.
    • An index can be used to efficiently find all rows matching some column in your query and then walk through only that subset of the table to find exact matches.If you don't have indexes on any column in the WHERE clause, the SQL server has to walk through the whole table and check every row to see if it matches, which may be a slow operation on big tables.
    • An index helps to speed up SELECT queries and WHERE clauses, but it slows down data input, with the UPDATE and the INSERT statements.

  4. #4
    Registered User
    Join Date
    May 2019
    Location
    Texas
    Posts
    9
    Indexes are used to retrieve data from the database very fast. The users cannot see the indexes, they are just used to speed up searches/queries. Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update)

  5. #5
    Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in a database is very similar to an index in the back of a book.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.