What is Indexing in Database ?<\/h2>\n<\/div>\n<\/div>\n

\n

\n

\n
• Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns that access the data in a database table.<\/li>\n
• An index object is created in database with the column\/columns value that are mentioned while creating the index.<\/li>\n
• The value in the index holds the row id of the physical data location in the database which helps for fast data retrieval of the corresponding rows.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
  \n

  <\/div>\n<\/div>\n

  \n

  \n

  Types Of Index<\/h2>\n<\/div>\n<\/div>\n

  \n

  \n

  \n
  • Clustered indexes<\/b>\u00a0define the physical sorting of a database table\u2019s rows in the storage media. For this reason, each database table may have only one clustered index.<\/li>\n
  • Non-clustered indexes<\/b>\u00a0are created outside of the database table and contain a sorted list of references to the table itself.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
    \n

    <\/div>\n<\/div>\n

    Cluster & Non Clustered Index<\/p>\n

    \n

    \n

    Advantages of Indexes<\/h2>\n<\/div>\n<\/div>\n

    \n

    \n

    \n
    • Indexes their use in queries usually results in much better performance.<\/li>\n
    • Make it possible to quickly retrieve (fetch) data.<\/li>\n
    • They can be used for sorting. A post-fetch-sort operation can be eliminated.<\/li>\n
    • Unique indexes guarantee uniquely identifiable records in the database.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
      \n

      \n

      Disadvantages of Indexes<\/h2>\n<\/div>\n<\/div>\n

      \n

      \n

      \n
      • They decrease performance on inserts, updates, and deletes.<\/li>\n
      • It will take up space (this increases with the number of fields used and the length of the fields).<\/li>\n
      • Some databases will monocase values in fields that are indexed.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        Answer : Indexing is the One of the ways that will optimize the database searching…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[195,7288,15897,360,203,199,214,198,363,6641,6662,7293,7284,209,7295,7306,7301,7299,6633,205,7285,7291,222,6615,6602,196,7290,6604,212,7300,7200,7287,7296,213,286,710,207,7286,7292,6636,366,204,282,15929,208,367,3715,206,7207,7298,6600,6617,7307,7305,6666,7297,7304,200,7302,7294,197,280,364,6632,7303,7289,285],"class_list":["post-1039","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-accenture-interview-questions-and-answers","tag-advantages-of-indexing-database","tag-apostek-software-interview-questions-and-answers","tag-atos-interview-questions-and-answers","tag-capgemini-interview-questions-and-answers","tag-casting-networks-india-pvt-limited-interview-questions-and-answers","tag-cgi-group-inc-interview-questions-and-answers","tag-chetu-interview-questions-and-answers","tag-ciena-corporation-interview-questions-and-answers","tag-clustered-and-nonclustered-indexes-in-sql","tag-clustered-index","tag-clustered-vs-nonclustered-index-performance","tag-clustering-index-in-dbms","tag-collabera-technologies-interview-questions-and-answers","tag-create-database","tag-create-index","tag-create-index-sql-server","tag-database-form","tag-database-index","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-dense-index","tag-disadvantages-of-indexes-in-sql","tag-flipkart-interview-questions-and-answers","tag-how-index-works-in-sql","tag-how-to-use-index-in-sql","tag-ibm-interview-questions-and-answers","tag-importance-of-index-in-a-book","tag-importance-of-indexing-in-database","tag-indecomm-global-services-interview-questions-and-answers","tag-index-table","tag-indexing-in-dbms","tag-indexing-in-sql","tag-indexing-service","tag-infosys-technologies-interview-questions-and-answers","tag-lt-infotech-interview-questions-and-answers","tag-mavenir-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-multilevel-indexing-definition","tag-multilevel-indexing-in-dbms","tag-mysql-index","tag-netapp-interview-questions-and-answers","tag-oracle-corporation-interview-questions-and-answers","tag-persistent-systems-interview-questions-and-answers","tag-polaris-financial-technology-interview-questions-and-answers","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-rbs-india-development-centre-pvt-ltd-interview-questions-and-answers","tag-ruboid-technovision-pvt-ltd-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-shell-infotech-interview-questions-and-answers","tag-sql-create-database","tag-sql-index","tag-sql-index-example","tag-sql-indexof","tag-sql-server-create-function","tag-sql-server-index","tag-sql-server-indexed-view","tag-sql-unique-index","tag-tech-mahindra-interview-questions-and-answers","tag-types-of-indexes-in-oracle","tag-types-of-indexes-in-sql","tag-unitedhealth-group-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-what-is-an-index","tag-what-is-indexing","tag-what-is-indexing-in-database","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers"],"yoast_head":"\n