{"id":1110,"date":"2024-12-15T18:02:41","date_gmt":"2024-12-15T15:02:41","guid":{"rendered":"https:\/\/fuatozer.com\/blog\/?p=1110"},"modified":"2024-12-15T18:02:41","modified_gmt":"2024-12-15T15:02:41","slug":"sql-index-nedir-cesitleri-nelerdir","status":"publish","type":"post","link":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/","title":{"rendered":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ?"},"content":{"rendered":"\n<p>SQL&#8217;de <strong>indexler<\/strong> (indeksler), veritaban\u0131 tablolar\u0131ndaki verilere daha h\u0131zl\u0131 eri\u015fmek i\u00e7in kullan\u0131lan veri yap\u0131lar\u0131d\u0131r. Sorgu performans\u0131n\u0131 art\u0131r\u0131r ancak yazma i\u015flemlerini (INSERT, UPDATE, DELETE) biraz yava\u015flatabilir, \u00e7\u00fcnk\u00fc indekslerin g\u00fcncellenmesi gerekir.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL&#8217;de Kullan\u0131lan Ba\u015fl\u0131ca \u0130ndeks T\u00fcrleri<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Clustered Index (K\u00fcmeleme \u0130ndeksi)<\/strong>\n<ul class=\"wp-block-list\">\n<li>Bir tablonun fiziksel veri s\u0131ras\u0131n\u0131 indeks s\u0131ras\u0131na g\u00f6re d\u00fczenler.<\/li>\n\n\n\n<li>Her tabloda yaln\u0131zca <strong>bir tane<\/strong> clustered index olabilir.<\/li>\n\n\n\n<li>Veriler do\u011frudan bu indeksle d\u00fczenlendi\u011fi i\u00e7in sorgu performans\u0131 y\u00fcksektir.<\/li>\n\n\n\n<li>Birincil anahtarlar (<strong>PRIMARY KEY<\/strong>) varsay\u0131lan olarak clustered index olur.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">CREATE CLUSTERED INDEX IX_TableName_ColumnName\nON TableName (ColumnName);\n<\/pre><\/div>\n\n\n\n<p><strong>Non-Clustered Index (K\u00fcmelenmemi\u015f \u0130ndeks)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Verileri fiziksel s\u0131raya g\u00f6re d\u00fczenlemez, ancak indeks s\u0131ras\u0131na g\u00f6re mant\u0131ksal bir yap\u0131 olu\u015fturur.<\/li>\n\n\n\n<li>Clustered index&#8217;in aksine, bir tabloda birden fazla non-clustered index olabilir.<\/li>\n\n\n\n<li>Genellikle SELECT sorgular\u0131nda filtreleme ve s\u0131ralama performans\u0131n\u0131 art\u0131rmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">CREATE NONCLUSTERED INDEX IX_TableName_ColumnName\nON TableName (ColumnName);\n<\/pre><\/div>\n\n\n\n<p><strong>Unique Index (Benzersiz \u0130ndeks)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Benzersiz de\u011ferler i\u00e7eren bir indeks t\u00fcr\u00fcd\u00fcr.<\/li>\n\n\n\n<li>Hem clustered hem de non-clustered olabilir.<\/li>\n\n\n\n<li>UNIQUE constraint ile benzer \u015fekilde \u00e7al\u0131\u015f\u0131r, ayn\u0131 s\u00fctunlarda tekrarl\u0131 de\u011ferlerin olu\u015fmas\u0131n\u0131 engeller.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">CREATE UNIQUE INDEX IX_TableName_ColumnName\nON TableName (ColumnName);\n<\/pre><\/div>\n\n\n\n<p><strong>Composite Index (Bile\u015fik \u0130ndeks)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Birden fazla s\u00fctun \u00fczerinde olu\u015fturulan bir indekstir.<\/li>\n\n\n\n<li>\u00d6zellikle, sorgular\u0131n\u0131z birden fazla s\u00fctunla \u00e7al\u0131\u015f\u0131yorsa faydal\u0131d\u0131r.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">CREATE NONCLUSTERED INDEX IX_TableName_Columns\nON TableName (Column1, Column2);\n<\/pre><\/div>\n\n\n\n<p><strong>Full-Text Index (Tam Metin \u0130ndeksi)<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B\u00fcy\u00fck metin alanlar\u0131nda (<strong>VARCHAR<\/strong>, <strong>TEXT<\/strong>, <strong>NVARCHAR<\/strong>) arama yapmak i\u00e7in kullan\u0131l\u0131r.<\/li>\n\n\n\n<li>Standart LIKE sorgular\u0131na g\u00f6re \u00e7ok daha h\u0131zl\u0131d\u0131r.<\/li>\n\n\n\n<li>Genellikle metin tabanl\u0131 verilerde belirli bir kelime veya ifade ararken kullan\u0131l\u0131r.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">CREATE FULLTEXT INDEX ON TableName(ColumnName)\nKEY INDEX PK_TableName;\n<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">\u0130ndeks Se\u00e7erken Dikkat Edilmesi Gerekenler<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Sorgu Performans\u0131<\/strong>:\n<ul class=\"wp-block-list\">\n<li>\u0130ndeks, SELECT, JOIN ve WHERE sorgular\u0131n\u0131 h\u0131zland\u0131rabilir.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Yazma Maliyeti<\/strong>:\n<ul class=\"wp-block-list\">\n<li>INSERT, UPDATE ve DELETE i\u015flemleri s\u0131ras\u0131nda indekslerin g\u00fcncellenmesi gerekti\u011fi i\u00e7in bu i\u015flemleri yava\u015flatabilir.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Disk Kullan\u0131m\u0131<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Fazla say\u0131da indeks olu\u015fturmak, disk alan\u0131 t\u00fcketimini art\u0131r\u0131r.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Uygun S\u00fctun Se\u00e7imi<\/strong>:\n<ul class=\"wp-block-list\">\n<li>S\u0131k\u00e7a sorgulanan s\u00fctunlar \u00fczerinde indeks olu\u015fturulmal\u0131d\u0131r.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Server&#8217;da \u0130ndeks G\u00f6r\u00fcnt\u00fcleme<\/h3>\n\n\n\n<p>Tablodaki mevcut indeksleri listelemek i\u00e7in a\u015fa\u011f\u0131daki sorgular kullan\u0131labilir:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:true,&quot;languageLabel&quot;:&quot;language&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;sql&quot;,&quot;mime&quot;:&quot;text\/x-sql&quot;,&quot;theme&quot;:&quot;lucario&quot;,&quot;lineNumbers&quot;:true,&quot;styleActiveLine&quot;:true,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;SQL&quot;,&quot;language&quot;:&quot;SQL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;sql&quot;}\">-- Mevcut indeksleri listeleme\nSELECT *\nFROM sys.indexes\nWHERE object_id = OBJECT_ID('TableName');\n<\/pre><\/div>\n\n\n\n<p>Bu bilgilerle indekslerinizi optimize ederek veritaban\u0131n\u0131z\u0131n performans\u0131n\u0131 art\u0131rabilirsiniz. \ud83d\ude0a<br><br><br><a href=\"https:\/\/medium.com\/trendyol-tech\/sql-server-index-yap%C4%B1s%C4%B1-aba652828fe2\n\">https:\/\/medium.com\/trendyol-tech\/sql-server-index-yap%C4%B1s%C4%B1-aba652828fe2<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/indexes?view=sql-server-ver16\">https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/indexes\/indexes?view=sql-server-ver16<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL&#8217;de indexler (indeksler), veritaban\u0131 tablolar\u0131ndaki verilere daha h\u0131zl\u0131 eri\u015fmek i\u00e7in kullan\u0131lan veri yap\u0131lar\u0131d\u0131r. Sorgu performans\u0131n\u0131 art\u0131r\u0131r ancak yazma i\u015flemlerini (INSERT, UPDATE, DELETE) biraz yava\u015flatabilir, \u00e7\u00fcnk\u00fc indekslerin g\u00fcncellenmesi gerekir. SQL&#8217;de Kullan\u0131lan Ba\u015fl\u0131ca \u0130ndeks T\u00fcrleri Non-Clustered Index (K\u00fcmelenmemi\u015f \u0130ndeks) Unique Index (Benzersiz \u0130ndeks) Composite Index (Bile\u015fik \u0130ndeks) Full-Text Index (Tam Metin \u0130ndeksi) \u0130ndeks Se\u00e7erken Dikkat Edilmesi Gerekenler<\/p>\n","protected":false},"author":1,"featured_media":1111,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,23],"tags":[58,59],"class_list":["post-1110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","category-veritabani","tag-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog<\/title>\n<meta name=\"description\" content=\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.\" \/>\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.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog\" \/>\n<meta property=\"og:description\" content=\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-15T15:02:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Faruk Fuat \u00d6zer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Fuat \u00d6zer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\"},\"author\":{\"name\":\"Faruk Fuat \u00d6zer\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5\"},\"headline\":\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ?\",\"datePublished\":\"2024-12-15T15:02:41+00:00\",\"dateModified\":\"2024-12-15T15:02:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\"},\"wordCount\":407,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5\"},\"image\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg\",\"keywords\":[\"sql\",\"sql server\"],\"articleSection\":[\"SQL Server\",\"Veritaban\u0131\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\",\"url\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\",\"name\":\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg\",\"datePublished\":\"2024-12-15T15:02:41+00:00\",\"dateModified\":\"2024-12-15T15:02:41+00:00\",\"description\":\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage\",\"url\":\"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg\",\"contentUrl\":\"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg\",\"width\":2560,\"height\":1440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/www.fuatozer.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#website\",\"url\":\"https:\/\/www.fuatozer.com\/blog\/\",\"name\":\"Blog\",\"description\":\"Yaz\u0131l\u0131mla alakal\u0131 her \u015fey\",\"publisher\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fuatozer.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5\",\"name\":\"Faruk Fuat \u00d6zer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4e31bcaa2c81b1fe5f740421577ccaac?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4e31bcaa2c81b1fe5f740421577ccaac?s=96&d=mm&r=g\",\"caption\":\"Faruk Fuat \u00d6zer\"},\"logo\":{\"@id\":\"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/fuatozer.com\/blog\",\"https:\/\/www.linkedin.com\/in\/fuatozerr\/\"],\"url\":\"https:\/\/www.fuatozer.com\/blog\/author\/fuatozerr23\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog","description":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.","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.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog","og_description":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.","og_url":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/","og_site_name":"Blog","article_published_time":"2024-12-15T15:02:41+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg","type":"image\/jpeg"}],"author":"Faruk Fuat \u00d6zer","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Faruk Fuat \u00d6zer","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#article","isPartOf":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/"},"author":{"name":"Faruk Fuat \u00d6zer","@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5"},"headline":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ?","datePublished":"2024-12-15T15:02:41+00:00","dateModified":"2024-12-15T15:02:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/"},"wordCount":407,"commentCount":0,"publisher":{"@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5"},"image":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg","keywords":["sql","sql server"],"articleSection":["SQL Server","Veritaban\u0131"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/","url":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/","name":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? - Blog","isPartOf":{"@id":"https:\/\/www.fuatozer.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage"},"image":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg","datePublished":"2024-12-15T15:02:41+00:00","dateModified":"2024-12-15T15:02:41+00:00","description":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ? ve di\u011fer t\u00fcm blog yaz\u0131lar\u0131m i\u00e7in Blog blog sayfam\u0131 ziyaret edebilirsiniz.","breadcrumb":{"@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#primaryimage","url":"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg","contentUrl":"https:\/\/www.fuatozer.com\/blog\/wp-content\/uploads\/2024\/12\/sql-scaled.jpeg","width":2560,"height":1440},{"@type":"BreadcrumbList","@id":"https:\/\/www.fuatozer.com\/blog\/sql-index-nedir-cesitleri-nelerdir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.fuatozer.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Index Nedir ? \u00c7e\u015fitleri nelerdir ?"}]},{"@type":"WebSite","@id":"https:\/\/www.fuatozer.com\/blog\/#website","url":"https:\/\/www.fuatozer.com\/blog\/","name":"Blog","description":"Yaz\u0131l\u0131mla alakal\u0131 her \u015fey","publisher":{"@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fuatozer.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/7551c59973f5913a0ff43db8e52662e5","name":"Faruk Fuat \u00d6zer","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4e31bcaa2c81b1fe5f740421577ccaac?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e31bcaa2c81b1fe5f740421577ccaac?s=96&d=mm&r=g","caption":"Faruk Fuat \u00d6zer"},"logo":{"@id":"https:\/\/www.fuatozer.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/fuatozer.com\/blog","https:\/\/www.linkedin.com\/in\/fuatozerr\/"],"url":"https:\/\/www.fuatozer.com\/blog\/author\/fuatozerr23\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/posts\/1110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/comments?post=1110"}],"version-history":[{"count":1,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/posts\/1110\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/posts\/1110\/revisions\/1112"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/media\/1111"}],"wp:attachment":[{"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/media?parent=1110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/categories?post=1110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fuatozer.com\/blog\/wp-json\/wp\/v2\/tags?post=1110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}