{"id":4875,"date":"2022-09-29T09:06:19","date_gmt":"2022-09-29T09:06:19","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=4875"},"modified":"2022-09-29T09:06:19","modified_gmt":"2022-09-29T09:06:19","slug":"what-are-all-the-different-attributes-of-indexes","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/","title":{"rendered":"What are all the different attributes of indexes ?"},"content":{"rendered":"<p style=\"text-align: justify;\">The indexing has various attributes:<\/p>\n<h3 id=\"access-types\" style=\"text-align: justify;\"><strong>Access Types<\/strong>:<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Value based search , range acess can be refered using Access types.<\/li>\n<\/ul>\n<h3 id=\"access-time\" style=\"text-align: justify;\"><strong>Access Time<\/strong>:<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Time that is needed to find a data element or a set of elements are called Access Time.<\/li>\n<\/ul>\n<h3 id=\"insertion-time\" style=\"text-align: justify;\"><strong>Insertion Time<\/strong>:<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Time needed to find an approriate space and insert a new data is known as Insertion Time.<\/li>\n<\/ul>\n<h3 id=\"deletion-time\" style=\"text-align: justify;\"><strong>Deletion Time<\/strong>:<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Time needed to find an element and delete that element as well as update its index structure is known as Deletion Time.<\/li>\n<\/ul>\n<h3 id=\"space-overhead\" style=\"text-align: justify;\"><strong>Space Overhead<\/strong>:<\/h3>\n<ul style=\"text-align: justify;\">\n<li>Index always needs additional space which is provided by the space overhead.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-4877 aligncenter\" src=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg\" alt=\"\" width=\"496\" height=\"427\" srcset=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg 496w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes-300x258.jpg 300w, https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes-390x336.jpg 390w\" sizes=\"(max-width: 496px) 100vw, 496px\" \/><\/p>\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"<p>The indexing has various attributes: Access Types: Value based search , range acess can be refered using Access types. Access Time: Time that is needed to find a data element or a set of elements are called Access Time. Insertion Time: Time needed to find an approriate space and insert a new data is known [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6547],"tags":[18671,18668,18666,6601,18672,18669,18667,7200,6596,18673,18591,18670],"class_list":["post-4875","post","type-post","status-publish","format-standard","hentry","category-sql","tag-attributes-of-an-index","tag-index-attribute","tag-indexed-attributes","tag-indexes-in-sql-server","tag-indexes-in-sql-server-with-examples","tag-indexing-attributes-in-the-identity-vault","tag-indexing-in-database","tag-indexing-in-dbms","tag-sql-indexes","tag-types-of-index-in-mysql","tag-types-of-indexes","tag-types-of-indexes-in-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What are all the different attributes of indexes ? - Wikitechy<\/title>\n<meta name=\"description\" content=\"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead\" \/>\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\/sql\/what-are-all-the-different-attributes-of-indexes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are all the different attributes of indexes ? - Wikitechy\" \/>\n<meta property=\"og:description\" content=\"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-29T09:06:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg\" \/>\n<meta name=\"author\" content=\"webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/\"},\"author\":{\"name\":\"webmaster\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"headline\":\"What are all the different attributes of indexes ?\",\"datePublished\":\"2022-09-29T09:06:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/\"},\"wordCount\":103,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/different-attributes-in-indexes.jpg\",\"keywords\":[\"attributes of an index\",\"index attribute\",\"indexed attributes\",\"Indexes in SQL Server\",\"indexes in sql server with examples\",\"indexing attributes in the identity vault\",\"indexing in database\",\"indexing in dbms\",\"SQL Indexes\",\"types of index in mysql\",\"types of indexes\",\"types of indexes in database\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/\",\"name\":\"What are all the different attributes of indexes ? - Wikitechy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/different-attributes-in-indexes.jpg\",\"datePublished\":\"2022-09-29T09:06:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/f785ba3ecc599133e65ab6138042a3e4\"},\"description\":\"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/what-are-all-the-different-attributes-of-indexes\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/different-attributes-in-indexes.jpg\",\"contentUrl\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/different-attributes-in-indexes.jpg\",\"width\":496,\"height\":427},{\"@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\\\/f785ba3ecc599133e65ab6138042a3e4\",\"name\":\"webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g\",\"caption\":\"webmaster\"},\"sameAs\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\"],\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/author\\\/webmaster\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What are all the different attributes of indexes ? - Wikitechy","description":"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead","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\/sql\/what-are-all-the-different-attributes-of-indexes\/","og_locale":"en_US","og_type":"article","og_title":"What are all the different attributes of indexes ? - Wikitechy","og_description":"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/","og_site_name":"Wikitechy","article_published_time":"2022-09-29T09:06:19+00:00","og_image":[{"url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg","type":"","width":"","height":""}],"author":"webmaster","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webmaster","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/"},"author":{"name":"webmaster","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"headline":"What are all the different attributes of indexes ?","datePublished":"2022-09-29T09:06:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/"},"wordCount":103,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg","keywords":["attributes of an index","index attribute","indexed attributes","Indexes in SQL Server","indexes in sql server with examples","indexing attributes in the identity vault","indexing in database","indexing in dbms","SQL Indexes","types of index in mysql","types of indexes","types of indexes in database"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/","name":"What are all the different attributes of indexes ? - Wikitechy","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg","datePublished":"2022-09-29T09:06:19+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/f785ba3ecc599133e65ab6138042a3e4"},"description":"What are all the different attributes of indexes ? - Access types - Access time - Insertion Time - Deletion Time - Space overhead","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/what-are-all-the-different-attributes-of-indexes\/#primaryimage","url":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg","contentUrl":"https:\/\/www.wikitechy.com\/interview-questions\/wp-content\/uploads\/2022\/09\/different-attributes-in-indexes.jpg","width":496,"height":427},{"@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\/f785ba3ecc599133e65ab6138042a3e4","name":"webmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/155b77fd8cdda3d0913fcb7e7ee63543b0c345d2d8f6dcebda5b0583ab61f967?s=96&d=mm&r=g","caption":"webmaster"},"sameAs":["https:\/\/www.wikitechy.com\/interview-questions"],"url":"https:\/\/www.wikitechy.com\/interview-questions\/author\/webmaster\/"}]}},"_links":{"self":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4875","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/comments?post=4875"}],"version-history":[{"count":1,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4875\/revisions"}],"predecessor-version":[{"id":4878,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/4875\/revisions\/4878"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=4875"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=4875"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=4875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}