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

Indexes In Sql

Index in SQL can be thought of as index of a book. Suppose, We have a book of 50 pages and we don't have indexes. Now if we have to navigate to a random topic then we have to start with first page and then second and so on, No problem here we...

Configuration files for AngularJS 2

Hello Everyone. Here,We will be going through a series of tutorials which aims at providing a basic understanding of AngularJS 2 framework. At its best,it will make you quite acquainted with the fundamentals of AngularJS 2. This is the firs...

What are Mysql Indexes

A database index is a structure that improves the speed of retrieval of data from our table. Index is similar to the index of a book. If you want to find a chapter you look in the index first without scanning the whole page. Users cannot see th...

How to delete an INDEX in a table in MySQL?

We can drop INDEX from table by using DROP INDEX statement, it is used to delete an index form a table. Syntax: ALTER TABLE table_name DROP INDEX index_name; Example: Suppose you have created an INDEX named "person_user_name_idx" on th...


The index is used to search the data in a table. The index is basically a data structure that search our data. It is applied usually on a column of a table. It is usually a B-tree but can also be hash table and other depending upon the ...
Sign In

Sign up using

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: