Indexes allow the database application to find data fast, without reading the whole table.The CREATE INDEX statement is used to create indexes in tables.
CREATE INDEX Syntax
CREATE UNIQUE INDEX Syntax
Create an index named username_index for the field username:
If you want to create an index on a combination of columns, you can list the column names within the parentheses, separated by commas as shown below
you can find more about index at : http://dev.mysql.com/doc/refman/5.0/en/create-index.html
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.