INDEXING:Being a developer, one of the most important point that we have to keep in mind is the optimisation. It is desirable that the queries in database returns the result fast as no-one like slow systems.Why indexing?Every time your web application runs a query, it will search through the rows linearly. As you can imagine, this can take a long time. Looking through every single row is very time consuming and not very efficient. It is fine for smaller tables but as the data grows, large number of rows need to be checked every time which will slow down the performance of database and hence the application crashes. That is when, Indexing comes into play.Conclusion: Tables increase in size and searching increases in execution time. What is indexing?Indexing is a process that helps you to access the data and retrieve the records in a database quickly. We can achieve indexing with the help of indexes. Indexes, a copy of selected columns of data from a table which contains a field value and a pointer.Working:Whenever we create the index of a column, basically, what the indexing process will do. It will create an another data structure that will contain a field value (the column values) and a pointer(the address to the record).In simple words, it will create a temporary table with the column values and the address pointing to each records. So, Using this temporary table, Instead of scanning the whole table it will directly scan the column with matching record.Please find the attached for more explanation.To be continued... - Study24x7
Social learning Network
Web Camp
58 followers study24x7 11 May 2020 07:34 PM study24x7 study24x7

INDEXING:Being a developer, one of the most important point that we have to keep in mind is the optimisation. It is desirable that the queries in database returns the result fast as no-one like slow systems.
Why indexing?
Every time your web application runs a query, it wil...

See more

INDEXING:Being a developer, one of the most important...
Databases Computer Programming Web Development
Like | 2 Comment Share | 1
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Popular Courses

Database Design All Levels English By Dr S Srinath
Free SEO training: SEO for beginner... Beginners Level English By Digital Marketing - Learn SEO, PPC,...
English Beginners Level English By Study Anywhere
H.C. Verma Solution All Levels English By HC Verma FanClub
SSC CGL, CPO, CHSL, GD Comprehensiv... All Levels English By Topline Coaching 3,999 5,499 27% off
English Special Course for SSC CGL,... All Levels English By Topline Coaching 999 1,499 33% off
Online Free SSC Mock Tests All Levels English By Topline Coaching
FREE MOCK TEST FOR SSC CGL All Levels English By SSC Preparation Strategies & Study ...
G.S. Foundation Premium Course All Levels हिन्दी By RAU IAS COACHING 2,199 4,199 48% off
Featured Courses
Popular Pages

Featured Courses

Database Design All Levels English By Dr S Srinath
FREE
5.0
Free SEO training: SEO for beginners Beginners Level English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
5.0
Free SEO Link Building Guide 2019 All Levels English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
4.5
BESTSELLER
SSC CGL, CPO, CHSL, GD Comprehensive Course All Levels English By Topline Coaching 3,999 5.0
A Premium Course For English Special (All One Day ... All Levels English By Vivishka Learning and Test Series 999 5.0
G.S. Foundation Premium Course All Levels हिन्दी By RAU IAS COACHING 2,199 5.0
English Special Course for SSC CGL, CPO, GD All Levels English By Topline Coaching 999 5.0
Online Free SSC Mock Tests All Levels English By Topline Coaching
FREE
4.5
Math Special Course for SSC CGL, CPO, GD All Levels हिन्दी By Topline Coaching 999 5.0

Popular Pages

SAT (Scholastic Assessment Test)

18 followers

Study24x7

1225 followers

Henry Harvin

61 followers

CBSE Study Materials

86 followers

Digital Marketing - Learn SEO, PPC, SMO,...

757 followers

Defence

106 followers

UPSC & State PSC

1010 followers

SSC Preparation Strategies & Study Mater...

1543 followers

Banking/IRDA

265 followers

DEFENCE EXAM PREPARATION

22 followers

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles