{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"Alt Sorgu Alternatifleri: CTE'leri Anlamak ve Kullanmak","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"kmiy1ReTF3\"><a href=\"https:\/\/fatihsoysal.com\/blog\/alt-sorgu-alternatifleri-cteleri-anlamak-ve-kullanmak\/\">Alt Sorgu Alternatifleri: CTE&#8217;leri Anlamak ve Kullanmak<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/alt-sorgu-alternatifleri-cteleri-anlamak-ve-kullanmak\/embed\/#?secret=kmiy1ReTF3\" width=\"600\" height=\"338\" title=\"&#8220;Alt Sorgu Alternatifleri: CTE&#8217;leri Anlamak ve Kullanmak&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"kmiy1ReTF3\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Veri tabanlar\u0131nda karma\u015f\u0131k sorgular yazarken s\u0131kl\u0131kla alt sorgular (subqueries) kullan\u0131r\u0131z. Ancak, \u00f6zellikle i\u00e7 i\u00e7e ge\u00e7mi\u015f alt sorgular s\u00f6z konusu oldu\u011funda, sorgular\u0131n okunabilirli\u011fi ve performans\u0131 d\u00fc\u015febilir. \u0130\u015fte tam bu noktada Ortak Tablo \u0130fadeleri (CTE - Common Table Expression) devreye giriyor. CTE'ler, SQL sorgular\u0131n\u0131 daha d\u00fczenli, anla\u015f\u0131l\u0131r ve optimize edilmi\u015f hale getirmek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r."}