{"id":1039,"date":"2021-07-19T10:36:39","date_gmt":"2021-07-19T10:36:39","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=1039"},"modified":"2021-09-09T06:14:59","modified_gmt":"2021-09-09T06:14:59","slug":"what-is-indexing-in-database","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/","title":{"rendered":"What is indexing in database ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"what-is-indexing-in-database\" class=\"color-pink\" style=\"text-align: justify;\">What is Indexing in Database ?<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>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<li>An index object is created in database with the column\/columns value that are mentioned while creating the index.<\/li>\n<li>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<div class=\"ImageContent\" style=\"text-align: justify;\">\n<div class=\"hddn\"><img decoding=\"async\" class=\"img-responsive center-block aligncenter\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png\" alt=\" What is Indexing Database\" \/><\/div>\n<\/div>\n<div class=\"TextHeading\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<h2 id=\"types-of-index\" class=\"color-green\">Types Of Index<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li><b>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<li><b>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<div class=\"ImageContent\" style=\"text-align: justify;\">\n<div class=\"hddn\"><img decoding=\"async\" class=\"img-responsive center-block aligncenter\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/difference-between-cluster-and-non-cluster-index.png\" alt=\"Cluster & Non Clustered Index\" \/><\/div>\n<\/div>\n<p style=\"text-align: justify;\" align=\"center\">Cluster & Non Clustered Index<\/p>\n<div class=\"TextHeading\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<h2 id=\"advantages-of-indexes\" class=\"color-blue\">Advantages of Indexes<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<ul>\n<li>Indexes their use in queries usually results in much better performance.<\/li>\n<li>Make it possible to quickly retrieve (fetch) data.<\/li>\n<li>They can be used for sorting. A post-fetch-sort operation can be eliminated.<\/li>\n<li>Unique indexes guarantee uniquely identifiable records in the database.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"TextHeading\" style=\"text-align: justify;\">\n<div class=\"hddn\">\n<h2 id=\"disadvantages-of-indexes\" class=\"color-blue\">Disadvantages of Indexes<\/h2>\n<\/div>\n<\/div>\n<div class=\"Content\">\n<div class=\"hddn\">\n<ul>\n<li style=\"text-align: justify;\">They decrease performance on inserts, updates, and deletes.<\/li>\n<li style=\"text-align: justify;\">It will take up space (this increases with the number of fields used and the length of the fields).<\/li>\n<li style=\"text-align: justify;\">Some databases will monocase values in fields that are indexed.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : Indexing is the One of the ways that will optimize the database searching&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"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":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is indexing in database ? - DBMS Interview Questions<\/title>\n<meta name=\"description\" content=\"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is indexing in database ? - DBMS Interview Questions\" \/>\n<meta property=\"og:description\" content=\"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-19T10:36:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-09T06:14:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png\" \/>\n<meta name=\"author\" content=\"Editor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Editor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"What is indexing in database ?\",\"datePublished\":\"2021-07-19T10:36:39+00:00\",\"dateModified\":\"2021-09-09T06:14:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/\"},\"wordCount\":224,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database.png\",\"keywords\":[\"Accenture interview questions and answers\",\"advantages of indexing database\",\"Apostek Software Interview Questions and Answers\",\"Atos interview questions and answers\",\"Capgemini interview questions and answers\",\"CASTING NETWORKS INDIA PVT LIMITED interview questions and answers\",\"CGI Group Inc interview questions and answers\",\"Chetu interview questions and answers\",\"Ciena Corporation interview questions and answers\",\"clustered and nonclustered indexes in sql\",\"clustered index\",\"clustered vs nonclustered index performance\",\"clustering index in dbms\",\"Collabera Technologies interview questions and answers\",\"create database\",\"create index\",\"create index sql server\",\"database form\",\"database index\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"dense index\",\"disadvantages of indexes in sql\",\"Flipkart interview questions and answers\",\"how index works in sql\",\"how to use index in sql\",\"IBM interview questions and answers\",\"importance of index in a book\",\"importance of indexing in database\",\"Indecomm Global Services interview questions and answers\",\"index table\",\"indexing in dbms\",\"indexing in sql\",\"indexing service\",\"Infosys Technologies interview questions and answers\",\"L&amp;T Infotech interview questions and answers\",\"Mavenir interview questions and answers\",\"Mphasis interview questions and answers\",\"multilevel indexing definition\",\"multilevel indexing in dbms\",\"mysql index\",\"NetApp interview questions and answers\",\"Oracle Corporation interview questions and answers\",\"Persistent Systems interview questions and answers\",\"polaris financial technology interview questions and answers\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"RBS India Development Centre Pvt Ltd interview questions and answers\",\"Ruboid Technovision Pvt Ltd interview questions and answers\",\"SAP Labs India Pvt Ltd interview questions and answers\",\"Shell Infotech interview questions and answers\",\"sql create database\",\"SQL Index\",\"sql index example\",\"sql indexof\",\"sql server create function\",\"sql server index\",\"sql server indexed view\",\"sql unique index\",\"Tech Mahindra interview questions and answers\",\"types of indexes in oracle\",\"types of indexes in sql\",\"UnitedHealth Group interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"what is an index\",\"what is indexing\",\"what is indexing in database\",\"Xoriant Solutions Pvt Ltd interview questions and answers\"],\"articleSection\":[\"DBMS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/\",\"name\":\"What is indexing in database ? - DBMS Interview Questions\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database.png\",\"datePublished\":\"2021-07-19T10:36:39+00:00\",\"dateModified\":\"2021-09-09T06:14:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database.png\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/dbms\\\/what-is-indexing-in-database.png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/\",\"name\":\"Wikitechy\",\"description\":\"Interview Questions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\",\"name\":\"Editor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g\",\"caption\":\"Editor\"},\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/editor\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is indexing in database ? - DBMS Interview Questions","description":"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/","og_locale":"en_US","og_type":"article","og_title":"What is indexing in database ? - DBMS Interview Questions","og_description":"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/","og_site_name":"Wikitechy","article_published_time":"2021-07-19T10:36:39+00:00","article_modified_time":"2021-09-09T06:14:59+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"What is indexing in database ?","datePublished":"2021-07-19T10:36:39+00:00","dateModified":"2021-09-09T06:14:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/"},"wordCount":224,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png","keywords":["Accenture interview questions and answers","advantages of indexing database","Apostek Software Interview Questions and Answers","Atos interview questions and answers","Capgemini interview questions and answers","CASTING NETWORKS INDIA PVT LIMITED interview questions and answers","CGI Group Inc interview questions and answers","Chetu interview questions and answers","Ciena Corporation interview questions and answers","clustered and nonclustered indexes in sql","clustered index","clustered vs nonclustered index performance","clustering index in dbms","Collabera Technologies interview questions and answers","create database","create index","create index sql server","database form","database index","Dell International Services India Pvt Ltd interview questions and answers","dense index","disadvantages of indexes in sql","Flipkart interview questions and answers","how index works in sql","how to use index in sql","IBM interview questions and answers","importance of index in a book","importance of indexing in database","Indecomm Global Services interview questions and answers","index table","indexing in dbms","indexing in sql","indexing service","Infosys Technologies interview questions and answers","L&amp;T Infotech interview questions and answers","Mavenir interview questions and answers","Mphasis interview questions and answers","multilevel indexing definition","multilevel indexing in dbms","mysql index","NetApp interview questions and answers","Oracle Corporation interview questions and answers","Persistent Systems interview questions and answers","polaris financial technology interview questions and answers","Prokarma Softech Pvt Ltd interview questions and answers","RBS India Development Centre Pvt Ltd interview questions and answers","Ruboid Technovision Pvt Ltd interview questions and answers","SAP Labs India Pvt Ltd interview questions and answers","Shell Infotech interview questions and answers","sql create database","SQL Index","sql index example","sql indexof","sql server create function","sql server index","sql server indexed view","sql unique index","Tech Mahindra interview questions and answers","types of indexes in oracle","types of indexes in sql","UnitedHealth Group interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","what is an index","what is indexing","what is indexing in database","Xoriant Solutions Pvt Ltd interview questions and answers"],"articleSection":["DBMS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/","name":"What is indexing in database ? - DBMS Interview Questions","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png","datePublished":"2021-07-19T10:36:39+00:00","dateModified":"2021-09-09T06:14:59+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"What is Indexing in Database ? - Indexing is the One of the ways that will optimize the database searching and accessing is having indexes on the columns","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/dbms\/what-is-indexing-in-database.png"},{"@type":"WebSite","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website","url":"https:\/\/www.wikitechy.com\/interview-questions\/","name":"Wikitechy","description":"Interview Questions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wikitechy.com\/interview-questions\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757","name":"Editor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e9531079fe7e07841b7b156c04d65e5f39d4adfd18b6ffe3edfff8ca5aab85b5?s=96&d=mm&r=g","caption":"Editor"},"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/editor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=1039"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1039\/revisions"}],"predecessor-version":[{"id":3110,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/1039\/revisions\/3110"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=1039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=1039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=1039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}