{"id":7259,"date":"2022-04-15T06:28:00","date_gmt":"2022-04-15T04:28:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=7259"},"modified":"2022-11-22T14:00:45","modified_gmt":"2022-11-22T13:00:45","slug":"creer-un-index-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/","title":{"rendered":"Cr\u00e9er un index SQL Server avec un script"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Cr\u00e9er un index SQL Server avec un script pour am\u00e9liorer les performances des requ\u00eates sur les tables et les vues cluster.<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel pour cr\u00e9er un index SQL Server de type cluster. En effet, il existe deux types d&rsquo;index, l&rsquo;index cluster et l&rsquo;index non cluster. Pour ajouter un index non cluster \u00e0 une table, utiliser cet exemple et adapter-le aux besoins du projet. Les index non cluster SQL Server contituent la premi\u00e8re \u00e9tape recommand\u00e9e pour l&rsquo;optimisation des performances en bases de donn\u00e9es.<\/p>\n\n\n\n<p>Tout d&rsquo;abord, c&rsquo;est un exemple basique pour montrer la commande T-SQL CREATE INDEX et comment il est relativement simple d&rsquo;optimiser les performances. Deuxi\u00e8mement, les deux colonnes index\u00e9es sont les colonnes typiques utilis\u00e9es dans l&rsquo;ex\u00e9cution de grandes requ\u00eates, c&rsquo;est-\u00e0-dire l&rsquo;ann\u00e9e et le mois. Une autre colonne tr\u00e8s courante est la date.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#1-les-index-cluster-sql-server\" >1. Les index cluster SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#2-creer-la-table-des-ventes-a-indexer-avec-sql-server\" >2. Cr\u00e9er la table des ventes \u00e0 indexer avec SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#3-ajouter-un-index-non-cluster-a-la-table-des-ventes\" >3. Ajouter un index non cluster \u00e0 la table des ventes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#4-verifier-lindex-sql-server-sur-la-table-depuis-ssms\" >4. V\u00e9rifier l&rsquo;index SQL Server sur la table depuis SSMS<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-les-index-cluster-sql-server\"><span class=\"ez-toc-section\" id=\"1-les-index-cluster-sql-server\"><\/span>1. Les index cluster SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tout d&rsquo;abord, la premi\u00e8re section explique comment cr\u00e9er un index sur une <a href=\"https:\/\/expert-only.com\/tables-sql-server\/\">table des ventes cr\u00e9e avec SQL Server<\/a>. Pourquoi les tr\u00e8s grandes tables, comme les ventes, ont besoin de colonnes index\u00e9es li\u00e9es \u00e0 la date ? Prenons l&rsquo;exemple d&rsquo;une entreprise ou d&rsquo;une organisation. Les responsables ont besoin de voir les chiffres dans un contexte pr\u00e9cis pour savoir si les ventes sont bonnes. <\/p>\n\n\n\n<p>Pour cela, le temps est <a href=\"https:\/\/expert-only.com\/concepts\/table-de-dimension-en-informatique-decisionnelle\/\">la principale dimension en business intelligence<\/a> parce que les comparaisons temporelles sont les plus courantes. Et parce que les responsables financiers des entreprises utilisent l&rsquo;ann\u00e9e fiscale comme r\u00e9f\u00e9rence. Les vues les plus populaires sont les vues annuelles, trimestrielles, mensuelles et quotidiennes. Et comme les donn\u00e9es \u00e9voluent le long de l&rsquo;<a href=\"https:\/\/fr.wiktionary.org\/wiki\/ann\u00e9e_fiscale\" target=\"_blank\" rel=\"noreferrer noopener\">ann\u00e9e fiscale<\/a>, les index \u00e9voluent et suivent la date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-creer-la-table-des-ventes-a-indexer-avec-sql-server\"><\/span>2. Cr\u00e9er la table des ventes \u00e0 indexer avec SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Par exemple, les tables de ventes ont cette structure initiale. Utilisez le code SQL suivant pour cr\u00e9er la table des ventes comme exemple pour la cr\u00e9ation de l&rsquo;index.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[SALES]\n(\n\t[Year] TINYINT,\n\t[MonthName] NVARCHAR(50),\n\t[MonthCurrent] BIT,\n\t[NumberMonth] TINYINT,\n\t[EmployeeNumber] SMALLINT,\n\t[NumberOfClients] INTEGER,\n\t[NumberOfSales] BIGINT,\n\t[Amount_ET] NUMERIC(15,5),\n\t[Amount_IT] DECIMAL(15,5)\n);\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"594\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\" alt=\"Cr\u00e9er une table des ventes pour y ajouter un index non cluster.\" class=\"wp-image-7279\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg 650w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server-300x274.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><figcaption class=\"wp-element-caption\"><strong>Cr\u00e9er une table des ventes avec SQL Server<\/strong><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-ajouter-un-index-non-cluster-a-la-table-des-ventes\"><\/span>3. Ajouter un index non cluster \u00e0 la table des ventes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, consid\u00e9rons que sur notre syst\u00e8me d&rsquo;analyse les colonnes principales utilis\u00e9es pour filtrer les donn\u00e9es. Il s&rsquo;agit de l&rsquo;ann\u00e9e et du nom du mois : Year et MonthName en Anglais.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE INDEX indexYearMonth\nON [dbo].[SALES] ([Year], [MonthName]);\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"362\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-sur-table-ventes-1.jpg\" alt=\"Cr\u00e9er un index SQL Server avec un script depuis SSMS\" class=\"wp-image-7290\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-sur-table-ventes-1.jpg 721w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-sur-table-ventes-1-300x151.jpg 300w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9er un index SQL Server avec un script depuis SSMS<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-verifier-lindex-sql-server-sur-la-table-depuis-ssms\"><\/span>4. V\u00e9rifier l&rsquo;index SQL Server sur la table depuis SSMS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>D\u00e9veloppez les propri\u00e9t\u00e9s de la table des ventes et v\u00e9rifiez la pr\u00e9sence de l&rsquo;index. Noter que par d\u00e9faut l&rsquo;index est un index non-unique et non-cluster.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"539\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-verifier-ssms.jpg\" alt=\"V\u00e9rifier la pr\u00e9sence et le type d'un index SQL Server avec SSMS. Depuis l'instance, s\u00e9lectionner la base de donn\u00e9es puis la table et sous Indexes v\u00e9rifier l'index, ici de type Non-Unique, Non-Clustered.\" class=\"wp-image-7296\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-verifier-ssms.jpg 416w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-index-sql-server-verifier-ssms-232x300.jpg 232w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><figcaption class=\"wp-element-caption\"><strong>V\u00e9rifier un index SQL Server avec SSMS<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>En outre, r\u00e9utiliser les exemples T-SQL ci-dessus. Le code est pr\u00eat \u00e0 \u00eatre copi\u00e9 et coll\u00e9, il suffit donc de l&rsquo;adapter et de l&rsquo;ex\u00e9cuter dans l&rsquo; <a href=\"https:\/\/expert-only.com\/ssms\/telecharger-sql-server-management-studio-18-ssms\/\">\u00e9diteur gratuit de requ\u00eate SQL Server Management Studio<\/a> (SSMS). En effet, toute requ\u00eate utilisant l&rsquo;ann\u00e9e et le mois dans la clause where utilise l&rsquo;index nouvellement cr\u00e9\u00e9. En d&rsquo;autres termes, l&rsquo;index <em>indexYearMonth<\/em> am\u00e9liore les performances de la requ\u00eate. La maintenance des index, comme les commandes reorganize et rebuild, permet de les maintenir efficaces.<\/p>\n\n\n\n<p>Pour aller plus loin, l&rsquo;\u00e9tape suivante consiste \u00e0 analyser et reconstruire l&rsquo;index afin d&rsquo;organiser les valeurs dans l&rsquo;index et les statistiques. Il est \u00e9galement disponible ci-dessous pour le t\u00e9l\u00e9chargement et la lecture hors ligne. Voici <a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/Creer-un-index-SQL-Server.pdf\">le tutoriel \u00e0 t\u00e9l\u00e9charger au format PDF<\/a>.<\/p>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file aligncenter\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/Creer-un-index-SQL-Server.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Contenu embarqu\u00e9 &lt;strong&gt;Creer-un-index-SQL-avec-un-script.pdf&lt;\/strong&gt;.\"><\/object><a id=\"wp-block-file--media-1d8a32b5-bfd0-4257-9d2d-a7de127315d8\" href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/Creer-un-index-SQL-Server.pdf\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Creer-un-index-SQL-avec-un-script.pdf<\/strong><\/a><a href=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/Creer-un-index-SQL-Server.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-1d8a32b5-bfd0-4257-9d2d-a7de127315d8\"><strong>T\u00e9l\u00e9charger<\/strong><\/a><\/div>\n\n\n\n<p>Voici ci-dessous un autre tutoriel sur le langage T-SQL avec <a href=\"https:\/\/expert-only.com\/t-sql\/pivot-sql-server\/\">la requ\u00eate PIVOT SQL Server pour transformer les lignes d&rsquo;une table en colonne<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ElrUrfncPt\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/\">Exemple de Requ\u00eate PIVOT SQL Server<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Exemple de Requ\u00eate PIVOT SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/pivot-sql-server\/embed\/#?secret=68qxZZcYwh#?secret=ElrUrfncPt\" data-secret=\"ElrUrfncPt\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Autres tutoriels sur les index SQL Server<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/reorganiser-un-index-sql-server\/\">R\u00e9organiser un index SQL Server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/desactiver-un-index-sql-server\/\">D\u00e9sactiver un index SQL server<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/t-sql\/supprimer-index-sql-server-script\/\">Supprimer un index SQL Server<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Cr\u00e9er un index SQL Server avec un script pour am\u00e9liorer les performances des requ\u00eates sur les tables et les vues cluster. Tutoriel pour cr\u00e9er un index SQL Server de type cluster. En effet, il existe deux types d&rsquo;index, l&rsquo;index <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\" title=\"Cr\u00e9er un index SQL Server avec un script\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[53],"class_list":{"0":"post-7259","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-t-sql","7":"tag-create"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cr\u00e9er un index SQL Server avec un script - Tutoriel T-SQL<\/title>\n<meta name=\"description\" content=\"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er un index SQL Server avec un script\" \/>\n<meta property=\"og:description\" content=\"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-15T04:28:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-22T13:00:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er un index SQL Server avec un script\",\"datePublished\":\"2022-04-15T04:28:00+00:00\",\"dateModified\":\"2022-11-22T13:00:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\"},\"wordCount\":668,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\",\"keywords\":[\"create\"],\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\",\"name\":\"Cr\u00e9er un index SQL Server avec un script - Tutoriel T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\",\"datePublished\":\"2022-04-15T04:28:00+00:00\",\"dateModified\":\"2022-11-22T13:00:45+00:00\",\"description\":\"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er un index SQL Server avec un script\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cr\u00e9er un index SQL Server avec un script - Tutoriel T-SQL","description":"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.","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:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er un index SQL Server avec un script","og_description":"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-04-15T04:28:00+00:00","article_modified_time":"2022-11-22T13:00:45+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg","type":"","width":"","height":""}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er un index SQL Server avec un script","datePublished":"2022-04-15T04:28:00+00:00","dateModified":"2022-11-22T13:00:45+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/"},"wordCount":668,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg","keywords":["create"],"articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/","name":"Cr\u00e9er un index SQL Server avec un script - Tutoriel T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg","datePublished":"2022-04-15T04:28:00+00:00","dateModified":"2022-11-22T13:00:45+00:00","description":"Cr\u00e9er un index avec SQL Server avec un script T-SQL pour ajouter un index non cluster \u00e0 une table et optimiser la performance des requ\u00eates.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/05\/creer-exemple-table-ventes-index-sql-server.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-un-index-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er un index SQL Server avec un script"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/7259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=7259"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/7259\/revisions"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=7259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=7259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=7259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}