{"id":538,"date":"2024-09-03T12:04:56","date_gmt":"2024-09-03T10:04:56","guid":{"rendered":"https:\/\/modedcon.com\/?page_id=538"},"modified":"2025-08-18T20:07:32","modified_gmt":"2025-08-18T18:07:32","slug":"sql-performance-analyse","status":"publish","type":"page","link":"https:\/\/modedcon.com\/de\/kurse\/sql-performance-analyse\/","title":{"rendered":"SQL-Performance Analyse"},"content":{"rendered":"\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:60%\">\n<p>Der Kurs ist auf 3 Tage ausgelegt. Es wird davon ausgegangen, dass die Teilnehmer zumindest Basis-Kenntnisse von SQL besitzen. Au\u00dferdem sollte das Konzept von logischen Dateien (DDS-beschriebene logische Dateien bzw. SQL Index) vertraut sein.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" style=\"margin-top:48px;margin-bottom:24px\">Inhalte<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Architektur der Datenbank<\/strong>\n<ul class=\"wp-block-list\">\n<li>Von CQE und SQE<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Abfrage Prozess<\/strong>\n<ul class=\"wp-block-list\">\n<li>Optimization Process\n<ul class=\"wp-block-list\">\n<li>Statistics Manager<\/li>\n\n\n\n<li>Access Plan<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Open Process\n<ul class=\"wp-block-list\">\n<li>Open Data Path (ODP)<\/li>\n\n\n\n<li>Full Open \/ Hard Close<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>AQP (Adaptive Query Processing)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Zugriffs-Methoden<\/strong>\n<ul class=\"wp-block-list\">\n<li>Permanente Objekte\n<ul class=\"wp-block-list\">\n<li>Table Scan \/ Table Probe<\/li>\n\n\n\n<li>Index Scan \/ Index Probe<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Verwendung von tempor\u00e4ren Objekten<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Indexing Strategy<\/strong>\n<ul class=\"wp-block-list\">\n<li>Zugriffswege\n<ul class=\"wp-block-list\">\n<li>Key Constraints \/ Binary Radix Indices<\/li>\n\n\n\n<li>Encoded Vector Indices<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Proactive \/ Reactive Indexing Strategy<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Analyse Feedback Tools<\/strong>\n<ul class=\"wp-block-list\">\n<li>Index Advisor \/ Condenser \/ Evaluator<\/li>\n\n\n\n<li>Visual Explain<\/li>\n\n\n\n<li>SQE Plan Cache (Snapshots)<\/li>\n\n\n\n<li>Database Monitors<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Verkn\u00fcpfen von Dateien<\/strong>\n<ul class=\"wp-block-list\">\n<li>Inner Join<\/li>\n\n\n\n<li>Left\/Right Outer Join<\/li>\n\n\n\n<li>Exception Join<\/li>\n\n\n\n<li>Cross Join<\/li>\n\n\n\n<li>Full Join<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Kodierungstipps<\/strong><\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>QAQQINI Optionen<\/strong><\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:5%\"><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:35%\">\n<div class=\"wp-block-group has-custom-bg-background-color has-background is-vertical is-layout-flex wp-container-core-group-is-layout-079504a7 wp-block-group-is-layout-flex\" style=\"padding-top:var(--wp--preset--spacing--10);padding-right:var(--wp--preset--spacing--10);padding-bottom:var(--wp--preset--spacing--10);padding-left:var(--wp--preset--spacing--10)\">\n<p class=\"hideonmobile\"><a href=\"https:\/\/modedcon.com\/kurse\" data-type=\"page\" data-id=\"74\">zur\u00fcck zur \u00dcbersicht<\/a><\/p>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-fe9cc265 wp-block-group-is-layout-flex\">\n<h2 class=\"wp-block-heading has-large-font-size\">Dieser Kurs<\/h2>\n\n\n\n<p>Teilnehmer: 8<br>Dauer: 3 Tage<\/p>\n\n\n\n<p class=\"has-custom-logo-red-color has-text-color has-link-color wp-elements-0769cf7e1cc07049e052ffe016fe898e\">Die Buchung ist nur f\u00fcr Unternehmer, Gewerbetreibende, Freiberufler und \u00f6ffentliche Institutionen m\u00f6glich; nicht f\u00fcr Verbraucher i.S.d. \u00a7 13 BGB.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-custom-logo-blue-background-color has-background wp-element-button\" href=\"https:\/\/modedcon.com\/kontakt\/\">Unverbindliche Anfrage stellen<\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-group is-vertical is-layout-flex wp-container-core-group-is-layout-5f9f5280 wp-block-group-is-layout-flex\">\n<h2 class=\"wp-block-heading has-large-font-size\">Alle Kurse<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">RPG<\/h3>\n\n\n\n<ul class=\"wp-block-list is-style-default\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/rpg-intro\/\" data-type=\"page\" data-id=\"515\">RPG \u2013 Intro<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/rpg-jump-start\/\" data-type=\"page\" data-id=\"521\">RPG \u2013 Jump-Start<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/ile-konzepte\/\" data-type=\"page\" data-id=\"525\">ILE Konzepte<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/embedded-sql\/\" data-type=\"page\" data-id=\"527\">Embedded SQL<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">SQL<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-abfragen-fuer-beginner\/\" data-type=\"page\" data-id=\"529\">SQL Abfragen f\u00fcr Beginner<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-abfragen-fuer-profis\/\" data-type=\"page\" data-id=\"531\">SQL Abfragen f\u00fcr Profis<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/erstellen-und-verarbeiten-von-json-und-xml-daten-mit-sql\/\" data-type=\"page\" data-id=\"533\">Erstellen und Verarbeiten von JSON- und XML-Daten mit SQL<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/programmiersprache-sql\/\" data-type=\"page\" data-id=\"535\">Programmiersprache SQL<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-performance-analyse\/\" data-type=\"page\" data-id=\"538\">SQL-Performance Analyse<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/data-centric-verlagerung-von-programmlogik-in-die-datenbank\/\" data-type=\"page\" data-id=\"540\">Data Centric Verlagerung von Programmlogik in die Datenbank<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/anwendungsmodernisierung-datenbank\/\" data-type=\"page\" data-id=\"542\">Anwendungsmodernisierung Datenbank<\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--20);margin-bottom:0.5rem;font-size:clamp(0.929rem, 0.929rem + ((1vw - 0.2rem) * 0.785), 1.4rem);\">Spezielle Kurse und Vortr\u00e4ge<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/temporale-tabellen\/\" data-type=\"page\" data-id=\"544\">Temporale Tabellen<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/row-and-column-access-control-rcac\/\" data-type=\"page\" data-id=\"546\">ROW and Column Access Control (RCAC)<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/partitioned-tables\/\" data-type=\"page\" data-id=\"548\">Partitioned Tables<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/self-sql-error-logging-facility\/\" data-type=\"page\" data-id=\"550\">SELF \u2013 SQL Error Logging Facility<\/a><\/li>\n\n\n\n<li style=\"margin-top:6px;margin-bottom:6px\"><a href=\"https:\/\/modedcon.com\/kurse\/sql-und-ifs\/\" data-type=\"page\" data-id=\"552\">SQL und IFS<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Der Kurs ist auf 3 Tage ausgelegt. Es wird davon ausgegangen, dass die Teilnehmer zumindest Basis-Kenntnisse von SQL besitzen. Au\u00dferdem sollte das Konzept von logischen Dateien (DDS-beschriebene logische Dateien bzw. SQL Index) vertraut sein. Inhalte zur\u00fcck zur \u00dcbersicht Dieser Kurs Teilnehmer: 8Dauer: 3 Tage Die Buchung ist nur f\u00fcr Unternehmer, Gewerbetreibende, Freiberufler und \u00f6ffentliche Institutionen [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":834,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-538","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/538","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/comments?post=538"}],"version-history":[{"count":14,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/538\/revisions"}],"predecessor-version":[{"id":986,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/538\/revisions\/986"}],"up":[{"embeddable":true,"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/pages\/834"}],"wp:attachment":[{"href":"https:\/\/modedcon.com\/de\/wp-json\/wp\/v2\/media?parent=538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}