Pros and cons of Indexing: Pros: 1. Speeds up the Searching process.(for SELECT statement) 2. Used to organize the rows that makes the searching process easier. For example: String data can be organized alphabetically, numerical data can be organized numerically, and where the data is a date it can still be organized by date. 3. Better performance 4. Indexes like primary key index and unique index help to avoid duplicate row data Cons: 1. Takes additional disk space 2. If the data is modified on regular intervals then the database engine requires updating all the indexes, thus too many indexes will slows down the performance. Hence, Slightly slower performance when adding or deleting records - Study24x7
Social learning Network
Web Camp
58 followers study24x7 11 May 2020 08:00 PM study24x7 study24x7

Pros and cons of Indexing: Pros: 1. Speeds up the Searching process.(for SELECT statement) 2. Used to organize the rows that makes the searching process easier. For example: String data can be organized alphabetically, numerical data can be organized numerically, and where the d...

See more

Pros and cons of Indexing: Pros: 1. Speeds up the Se...
Databases Computer Programming Web Development
Like | 2 Comment | 1 Share | 3
study24x7
Write a comment
  • prem shankar
    • Thanks web camp it is so important topic for me..Please describe more with proper live industrial examples..... also explain with types of indexing.....
    Like
    Reply 1 12 May 2020 11:38 AM
    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