{"id":23079,"date":"2013-05-13T15:01:07","date_gmt":"2013-05-13T09:31:07","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=23079"},"modified":"2024-04-12T14:23:40","modified_gmt":"2024-04-12T08:53:40","slug":"create-drop-and-alter-index","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/","title":{"rendered":"Create, Drop and alter index"},"content":{"rendered":"\n

Create, Drop and alter index<\/strong><\/p>\n\n\n\n

In SQL Server 2008, an index is a database object that improves the performance of queries by providing a fast and efficient way to retrieve data from a table. Indexes can be created, dropped, and altered using SQL commands.<\/p>\n\n\n\n

Here’s a brief overview of how to create, drop, and alter indexes in SQL Server 2008:<\/p>\n\n\n\n

Create Index:<\/p>\n\n\n\n

To create an index, you can use the CREATE INDEX statement followed by the name of the index, the table name, and the columns to include in the index. Here’s an example:<\/p>\n\n\n\n

arduino<\/p>\n\n\n\n

CREATE INDEX idx_name ON table_name (column1, column2);<\/code><\/pre>\n\n\n\n
This will create an index named “idx_name” on the “table_name” table, using the “column1” and “column2” columns.<\/p>\n\n\n\n
Drop Index:<\/p>\n\n\n\n
To drop an index, you can use the DROP INDEX statement followed by the name of the index and the table name. Here’s an example:<\/p>\n\n\n\n
graphql<\/p>\n\n\n\n
DROP INDEX idx_name ON table_name;<\/code><\/pre>\n\n\n\n
This will drop the “idx_name” index from the “table_name” table.<\/p>\n\n\n\n
Alter Index:<\/p>\n\n\n\n
To alter an index, you can use the ALTER INDEX statement followed by the name of the index, the table name, and the options you want to modify. Here’s an example:<\/p>\n\n\n\n
graphql<\/p>\n\n\n\n
ALTER INDEX idx_name ON table_name REBUILD;<\/code><\/pre>\n\n\n\n
This will rebuild the “idx_name” index on the “table_name” table.<\/p>\n\n\n\n
In addition to rebuilding an index, you can also use the ALTER INDEX statement to disable or enable an index, or to modify its properties such as the fill factor or partition scheme. It’s important to note that creating, dropping, or altering an index can have an impact on the performance of your database queries, so it’s important to carefully consider the indexes you create and maintain them regularly.<\/p>\n\n\n\n
Apply for SQL Server 2008 Certification!!<\/strong><\/h3>\n\n\n\n
https:\/\/www.vskills.in\/certification\/certified-sql-server-2008-programmer<\/a><\/p>\n\n\n\n
Back to Tutorials<\/strong><\/a><\/h4>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Create, Drop and alter index In SQL Server 2008, an index is a database object that improves the performance of queries by providing a fast and efficient way to retrieve data from a table. Indexes can be created, dropped, and altered using SQL commands. Here’s a brief overview of how to create, drop, and alter…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[322],"tags":[],"class_list":["post-23079","page","type-page","status-publish","hentry","category-sql-server-2008"],"acf":[],"yoast_head":"\nCreate, Drop and alter index tutorials<\/title>\n<meta name=\"description\" content=\"Create, Drop and alter index tutorials\" \/>\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.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create, Drop and alter index tutorials\" \/>\n<meta property=\"og:description\" content=\"Create, Drop and alter index tutorials\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:53:40+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/\",\"name\":\"Create, Drop and alter index tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2013-05-13T09:31:07+00:00\",\"dateModified\":\"2024-04-12T08:53:40+00:00\",\"description\":\"Create, Drop and alter index tutorials\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create, Drop and alter index\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create, Drop and alter index tutorials","description":"Create, Drop and alter index tutorials","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.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/","og_locale":"en_US","og_type":"article","og_title":"Create, Drop and alter index tutorials","og_description":"Create, Drop and alter index tutorials","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:53:40+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/","name":"Create, Drop and alter index tutorials","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2013-05-13T09:31:07+00:00","dateModified":"2024-04-12T08:53:40+00:00","description":"Create, Drop and alter index tutorials","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/create-drop-and-alter-index\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Create, Drop and alter index"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23079","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=23079"}],"version-history":[{"count":5,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23079\/revisions"}],"predecessor-version":[{"id":133856,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/23079\/revisions\/133856"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=23079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=23079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=23079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}