{"id":965,"date":"2021-07-18T20:18:58","date_gmt":"2021-07-18T20:18:58","guid":{"rendered":"https:\/\/www.wikitechy.com\/interview-questions\/?p=965"},"modified":"2021-09-09T09:59:57","modified_gmt":"2021-09-09T09:59:57","slug":"difference-between-clustered-and-non-clustered-index","status":"publish","type":"post","link":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/","title":{"rendered":"Difference between Clustered and Non-clustered index ?"},"content":{"rendered":"<div class=\"TextHeading\">\n<div class=\"hddn\">\n<h2 id=\"difference-between-clustered-and-non-clustered-index\" class=\"color-pink\">Difference between Clustered and Non-clustered index ?<\/h2>\n<table class=\"table-bordered table-striped table table-responsive\">\n<tbody>\n<tr>\n<th>Clustered Index<\/th>\n<th>Non-clustered Index<\/th>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Clustered index will be created by default<br \/>\nwhen you create primary key on a column.<br \/>\nSo we can create one clustered index per table.<\/td>\n<td class=\"text-leftalign\">Non clustered index will be created automatically when you create unique key on a column. A table can have no.of unique keys, so we can create no.of non-clustered indexes per table.<\/td>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">The Leaf Level of a clustered index<br \/>\nis the actual data page.<\/td>\n<td class=\"text-leftalign\">The Leaf Level of a non-clustered index does not consist of the actual data page.<\/td>\n<\/tr>\n<tr>\n<td class=\"text-leftalign\">Only one clustered index can be created.<\/td>\n<td class=\"text-leftalign\">Many non clustered index(Numbers depends on the database software) can be created.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div class=\"text-center row\">\n<div class=\"col-sm-12\">\n<div id=\"bsa-zone_1590522538159-8_123456\"><\/div>\n<\/div>\n<\/div>\n<div class=\"ImageContent\">\n<div class=\"hddn\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.png\" alt=\"Cluster and Non Cluster Index\" width=\"541\" height=\"447\" \/><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Answer : Cluster index: Clustered index will be created&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6547],"tags":[195,6595,203,199,214,198,6663,6645,6646,6677,6668,6662,6681,6651,6652,6614,6653,6647,6649,6678,6648,6676,6679,209,283,6650,6671,1867,6633,205,6613,6670,6680,2936,222,484,6654,6655,6656,6657,6658,196,212,6626,286,970,207,6664,6659,6674,6682,204,282,6672,208,288,206,6673,6665,6600,6627,6675,6667,6666,975,200,197,284,280,364,6660,6661,285,15882],"class_list":["post-965","post","type-post","status-publish","format-standard","hentry","category-sql","tag-accenture-interview-questions-and-answers","tag-allstate-solut-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-cluster","tag-cluster-index-creation","tag-cluster-index-in-oracle","tag-cluster-meaning","tag-clustered-and-nonclustered-index","tag-clustered-index","tag-clustered-index-and-non-clustered-index","tag-clustered-index-in-mysql","tag-clustered-index-in-oracle","tag-clustered-index-in-sql","tag-clustered-index-in-sql-server-2008-with-example","tag-clustered-index-mysql","tag-clustered-index-performance","tag-clustered-index-vs-nonclustered-index","tag-clustered-vs-non","tag-clustered-vs-nonclustered-index","tag-clustering","tag-collabera-technologies-interview-questions-and-answers","tag-conduent-interview-questions-and-answers","tag-create-non-clustered-index-multiple-columns-sql-server","tag-create-nonclustered-index","tag-database","tag-database-index","tag-dell-international-services-india-pvt-ltd-interview-questions-and-answers","tag-difference-between-clustered-and-non","tag-difference-between-clustered-and-nonclustered-index","tag-difference-between-clustered-index-and-non-clustered-index","tag-fis-global-business-solutions-india-pvt-ltd-interview-questions-and-answers","tag-flipkart-interview-questions-and-answers","tag-genpact-interview-questions-and-answers","tag-how-many-clustered-index-in-a-table","tag-how-non-clustered-index-point-to-the-data","tag-how-to-create-clustered-index-in-sql","tag-how-to-create-non-clustered-index-in-oracle","tag-how-to-create-non-clustered-index-in-sql-server","tag-ibm-interview-questions-and-answers","tag-indecomm-global-services-interview-questions-and-answers","tag-index","tag-lt-infotech-interview-questions-and-answers","tag-mindtree-interview-questions-and-answers","tag-mphasis-interview-questions-and-answers","tag-non-clustered-index","tag-non-clustered-index-example","tag-non-clustered-index-in-sql","tag-non-clustered-index-in-sql-server","tag-oracle-corporation-interview-questions-and-answers","tag-persistent-systems-interview-questions-and-answers","tag-primary-key-clustered","tag-prokarma-softech-pvt-ltd-interview-questions-and-answers","tag-r-systems-interview-questions-and-answers","tag-sap-labs-india-pvt-ltd-interview-questions-and-answers","tag-sql-cluster","tag-sql-create-index","tag-sql-index","tag-sql-server","tag-sql-server-cluster","tag-sql-server-clustered-index","tag-sql-server-index","tag-tata-consultancy-service-interview-questions-and-answers","tag-tech-mahindra-interview-questions-and-answers","tag-unitedhealth-group-interview-questions-and-answers","tag-valuelabs-interview-questions-and-answers","tag-virtusa-consulting-services-pvt-ltd-interview-questions-and-answers","tag-wells-fargo-interview-questions-and-answers","tag-when-to-use-non-clustered-index","tag-which-is-faster-clustered-or-non","tag-xoriant-solutions-pvt-ltd-interview-questions-and-answers","tag-yardi-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>Difference between Clustered and Non-clustered index ? - SQL<\/title>\n<meta name=\"description\" content=\"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.\" \/>\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\/difference-between-clustered-and-non-clustered-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Difference between Clustered and Non-clustered index ? - SQL\" \/>\n<meta property=\"og:description\" content=\"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/\" \/>\n<meta property=\"og:site_name\" content=\"Wikitechy\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-18T20:18:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-09T09:59:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.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=\"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\\\/difference-between-clustered-and-non-clustered-index\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/\"},\"author\":{\"name\":\"Editor\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"headline\":\"Difference between Clustered and Non-clustered index ?\",\"datePublished\":\"2021-07-18T20:18:58+00:00\",\"dateModified\":\"2021-09-09T09:59:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/\"},\"wordCount\":120,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-cluster-and-non-cluster-index.png\",\"keywords\":[\"Accenture interview questions and answers\",\"Allstate Solut 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\",\"cluster\",\"cluster index creation\",\"cluster index in oracle\",\"cluster meaning\",\"clustered and nonclustered index\",\"clustered index\",\"clustered index and non clustered index\",\"clustered index in mysql\",\"clustered index in oracle\",\"clustered index in sql\",\"clustered index in sql server 2008 with example\",\"clustered index mysql\",\"clustered index performance\",\"clustered index vs nonclustered index\",\"clustered vs non\",\"clustered vs nonclustered index\",\"clustering\",\"Collabera Technologies interview questions and answers\",\"Conduent interview questions and answers\",\"create non clustered index multiple columns sql server\",\"create nonclustered index\",\"database\",\"database index\",\"Dell International Services India Pvt Ltd interview questions and answers\",\"difference between clustered and non\",\"difference between clustered and nonclustered index\",\"difference between clustered index and non clustered index\",\"FIS Global Business Solutions India Pvt Ltd interview questions and answers\",\"Flipkart interview questions and answers\",\"Genpact interview questions and answers\",\"how many clustered index in a table\",\"how non clustered index point to the data\",\"how to create clustered index in sql\",\"how to create non clustered index in oracle\",\"how to create non clustered index in sql server\",\"IBM interview questions and answers\",\"Indecomm Global Services interview questions and answers\",\"index\",\"L&amp;T Infotech interview questions and answers\",\"Mindtree interview questions and answers\",\"Mphasis interview questions and answers\",\"non clustered index\",\"non clustered index example\",\"non clustered index in sql\",\"non clustered index in sql server\",\"Oracle Corporation interview questions and answers\",\"Persistent Systems interview questions and answers\",\"primary key clustered\",\"Prokarma Softech Pvt Ltd interview questions and answers\",\"R Systems interview questions and answers\",\"SAP Labs India Pvt Ltd interview questions and answers\",\"sql cluster\",\"sql create index\",\"SQL Index\",\"sql server\",\"sql server cluster\",\"sql server clustered index\",\"sql server index\",\"Tata Consultancy Service interview questions and answers\",\"Tech Mahindra interview questions and answers\",\"UnitedHealth Group interview questions and answers\",\"ValueLabs interview questions and answers\",\"Virtusa Consulting Services Pvt Ltd interview questions and answers\",\"Wells Fargo interview questions and answers\",\"when to use non clustered index\",\"which is faster clustered or non\",\"Xoriant Solutions Pvt Ltd interview questions and answers\",\"yardi interview questions and answers\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/\",\"url\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/\",\"name\":\"Difference between Clustered and Non-clustered index ? - SQL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-cluster-and-non-cluster-index.png\",\"datePublished\":\"2021-07-18T20:18:58+00:00\",\"dateModified\":\"2021-09-09T09:59:57+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/#\\\/schema\\\/person\\\/4d5a581fb5470d1560324bddc5e8b757\"},\"description\":\"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-clustered-and-non-clustered-index\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-cluster-and-non-cluster-index.png\",\"contentUrl\":\"https:\\\/\\\/cdn.wikitechy.com\\\/interview-questions\\\/sql\\\/difference-between-cluster-and-non-cluster-index.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":"Difference between Clustered and Non-clustered index ? - SQL","description":"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.","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\/difference-between-clustered-and-non-clustered-index\/","og_locale":"en_US","og_type":"article","og_title":"Difference between Clustered and Non-clustered index ? - SQL","og_description":"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.","og_url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/","og_site_name":"Wikitechy","article_published_time":"2021-07-18T20:18:58+00:00","article_modified_time":"2021-09-09T09:59:57+00:00","og_image":[{"url":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.png","type":"","width":"","height":""}],"author":"Editor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Editor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#article","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/"},"author":{"name":"Editor","@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"headline":"Difference between Clustered and Non-clustered index ?","datePublished":"2021-07-18T20:18:58+00:00","dateModified":"2021-09-09T09:59:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/"},"wordCount":120,"commentCount":0,"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.png","keywords":["Accenture interview questions and answers","Allstate Solut 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","cluster","cluster index creation","cluster index in oracle","cluster meaning","clustered and nonclustered index","clustered index","clustered index and non clustered index","clustered index in mysql","clustered index in oracle","clustered index in sql","clustered index in sql server 2008 with example","clustered index mysql","clustered index performance","clustered index vs nonclustered index","clustered vs non","clustered vs nonclustered index","clustering","Collabera Technologies interview questions and answers","Conduent interview questions and answers","create non clustered index multiple columns sql server","create nonclustered index","database","database index","Dell International Services India Pvt Ltd interview questions and answers","difference between clustered and non","difference between clustered and nonclustered index","difference between clustered index and non clustered index","FIS Global Business Solutions India Pvt Ltd interview questions and answers","Flipkart interview questions and answers","Genpact interview questions and answers","how many clustered index in a table","how non clustered index point to the data","how to create clustered index in sql","how to create non clustered index in oracle","how to create non clustered index in sql server","IBM interview questions and answers","Indecomm Global Services interview questions and answers","index","L&amp;T Infotech interview questions and answers","Mindtree interview questions and answers","Mphasis interview questions and answers","non clustered index","non clustered index example","non clustered index in sql","non clustered index in sql server","Oracle Corporation interview questions and answers","Persistent Systems interview questions and answers","primary key clustered","Prokarma Softech Pvt Ltd interview questions and answers","R Systems interview questions and answers","SAP Labs India Pvt Ltd interview questions and answers","sql cluster","sql create index","SQL Index","sql server","sql server cluster","sql server clustered index","sql server index","Tata Consultancy Service interview questions and answers","Tech Mahindra interview questions and answers","UnitedHealth Group interview questions and answers","ValueLabs interview questions and answers","Virtusa Consulting Services Pvt Ltd interview questions and answers","Wells Fargo interview questions and answers","when to use non clustered index","which is faster clustered or non","Xoriant Solutions Pvt Ltd interview questions and answers","yardi interview questions and answers"],"articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/","url":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/","name":"Difference between Clustered and Non-clustered index ? - SQL","isPartOf":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#primaryimage"},"image":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.png","datePublished":"2021-07-18T20:18:58+00:00","dateModified":"2021-09-09T09:59:57+00:00","author":{"@id":"https:\/\/www.wikitechy.com\/interview-questions\/#\/schema\/person\/4d5a581fb5470d1560324bddc5e8b757"},"description":"Difference between Clustered and Non-clustered index ? - SQL - Clustered index: Clustered index will be created by default when you create primary key on a column.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.wikitechy.com\/interview-questions\/sql\/difference-between-clustered-and-non-clustered-index\/#primaryimage","url":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.png","contentUrl":"https:\/\/cdn.wikitechy.com\/interview-questions\/sql\/difference-between-cluster-and-non-cluster-index.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\/965","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=965"}],"version-history":[{"count":3,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/965\/revisions"}],"predecessor-version":[{"id":3174,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/posts\/965\/revisions\/3174"}],"wp:attachment":[{"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/media?parent=965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/categories?post=965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wikitechy.com\/interview-questions\/wp-json\/wp\/v2\/tags?post=965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}