Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Indexing in Mysql

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 325
    Comment on it

    Indexing is useful for faster searching of data. Suppose you have a product table in your database with more than 2,00,000 records, now when you search a record on basis of product name, it takes time too long. Now if you want to perform your search faster. Create index for product_name fields by following command

    CREATE UNIQUE INDEX AUTHOR_INDEX ON product_tbl (product_name DESC)

    Now do a search again and lets enjoy the magic.

    Behind this magic: In the real world, indexing is also a type of database table, which keep primary key or index field and a pointer to each record into the actual table. User can not see the indexes, this is just used to speed up queries and will be used by Database Search Engine to search record faster.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: