{"id":2896,"date":"2021-03-22T08:00:00","date_gmt":"2021-03-22T05:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2896"},"modified":"2025-01-15T14:35:22","modified_gmt":"2025-01-15T11:35:22","slug":"pos-tha-veltiosoyme-ena-query-poy-trechei-se-v","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/","title":{"rendered":"How to improve the performance of a query running on an Oracle database (SQL Tuning Advisor)"},"content":{"rendered":"<p>Many times we will hear that a query that was running fast suddenly started to run slowly or that a query is running unreasonably very slowly.<\/p>\n\n\n\n<p>The easiest way to find what&#039;s wrong and fix it is by running it <strong>SQL Tuning Advisor<\/strong> of Oracle. <\/p>\n\n\n\n<p>During its execution for the specific query, it collects information from various sources (as we will see in the image below) and at the end makes suggestions to improve the performance of the query.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"572\" height=\"434\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-01.png\" alt=\"\" class=\"wp-image-2908\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-01.png 572w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-01-300x228.png 300w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><figcaption class=\"wp-element-caption\">docs.oracle.com<\/figcaption><\/figure>\n\n\n\n<p>The recommendations he suggests we make might be:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>To get statistics on specific tables as they are stale<\/li>\n\n\n\n<li>Let&#039;s create new indexes<\/li>\n\n\n\n<li>Let&#039;s change the way the query is written<\/li>\n\n\n\n<li>Use a SQL profile to force a different plan for the query<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"422\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-02.png\" alt=\"\" class=\"wp-image-2909\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-02.png 338w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2021\/02\/ota-02-240x300.png 240w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><figcaption class=\"wp-element-caption\">docs.oracle.com<\/figcaption><\/figure>\n\n\n\n<p>To use the SQL Tuning Advisor we must have <strong>Enterprise<\/strong> version of Oracle or have purchased it <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/license.111\/b28287\/options.htm#DBLIC169\" target=\"_blank\" rel=\"noreferrer noopener\">Tuning Pack<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The example<\/h2>\n\n\n\n<p>First we have to find it <strong>SQL_ID <\/strong>from the query we want to see. If we don&#039;t have it <strong>SQL_ID<\/strong> <a href=\"https:\/\/www.dataplatform.gr\/en\/pos-vriskoyme-grigora-ti-trechei-se-mia\/\" target=\"_blank\" rel=\"noreferrer noopener\">in this article<\/a> you can see how you will find it easily.<\/p>\n\n\n\n<p>Then we have to fix it <strong>tuning task <\/strong>completing it <strong>SQL_ID <\/strong>and giving one <strong>TASK_NAME<\/strong>.<\/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=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">declare\ntask_nm varchar2(100);\nbegin\ntask_nm := dbms_sqltune.create_tuning_task(SQL_ID=> '5t5mxfm0ph3n0',TASK_NAME => 'SQL_TUNNING_TASK_5t5mxfm0ph3n0');\nend;\n\/<\/pre>\n\n\n\n<p>Then we run the tuning task we created before.<\/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=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">exec dbms_sqltune.execute_tuning_task (TASK_NAME => 'SQL_TUNNING_TASK_5t5mxfm0ph3n0');<\/pre>\n\n\n\n<p>After it is completed, we see the results from the analysis with the following select query:<\/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=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">SET LONG 10000;\nSET PAGESIZE 1000;\nSET LINESIZE 200;\nSELECT DBMS_SQLTUNE.report_tuning_task('SQL_TUNNING_TASK_5t5mxfm0ph3n0') AS recommendations FROM dual;\nSET PAGESIZE 24;<\/pre>\n\n\n\n<p>In the results we will see in three different sections.<\/p>\n\n\n\n<p>The <strong>General Section <\/strong>which contains the <strong>SQL text<\/strong>.<\/p>\n\n\n\n<p>The <strong>Finding Sections <\/strong>which contains the sentences he found such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Statistics Finding<\/strong>: Creating statistics in one <em>stale <\/em>table that the query reads<\/li>\n\n\n\n<li><strong>Index Finding<\/strong>: Which suggests the creation <em>index <\/em>in the field that was in the where clause<\/li>\n\n\n\n<li><strong>SQL Profile Finding<\/strong>: Suggests to enable it <em>SQL Profile<\/em> that he created that makes use of a better plan<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>End of <strong>Explain Plan Section <\/strong>it analyzes the two different plans, one that has run the query and the other that it suggests.<\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\" data-no-auto-translation=\"\"><code>RECOMMENDATIONS\n--------------------------------------------------------------------------------\nGENERAL INFORMATION SECTION\n-------------------------------------------------------------------------------\nTuning Task Name   : SQL_TUNNING_TASK_5t5mxfm0ph3n0\nTuning Task Owner  : SYS\nWorkload Type      : Single SQL Statement\nScope              : COMPREHENSIVE\nTime Limit(seconds): 1800\nCompletion Status  : COMPLETED\nStarted at         : 01\/01\/2021 17:22:25\nCompleted at       : 01\/01\/2021 17:22:54\n\n-------------------------------------------------------------------------------\nSchema Name: USERS\nSQL ID     : 5t5mxfm0ph3n0\nSQL Text   : SELECT   TR.NAME,\n                                                                  TR.AGE,\n                                                                  TR.CITY,\n                                                                  TR.SIGN_DATE\n                                                            FROM    USERS.CUSTOMERS TR\n                                                            WHERE   \n                                                                  TR.SIGN_DATE  = TO_DATE('30\/12\/2020','DD\/MM\/YYYY')\n\n-------------------------------------------------------------------------------\nFINDINGS SECTION (3 findings)\n-------------------------------------------------------------------------------\n\n1- Statistics Finding\n---------------------\n  Optimizer statistics for table \"USERS\".\"CUSTOMERS\" are stale.\n\n  Recommendation\n  --------------\n  - Consider collecting optimizer statistics for this table and its indices.\n    execute dbms_stats.gather_table_stats(ownname =&gt; 'USERS', tabname =&gt;\n            'CUSTOMERS', estimate_percent =&gt;\n            DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt =&gt; 'FOR ALL COLUMNS SIZE\n            AUTO', cascade =&gt; TRUE);\n\n  Rationale\n  ---------\n    The optimizer requires up-to-date statistics for the table and its indices\n    in order to select a good execution plan.\n\n\n2- Index Finding (see explain plans section below)\n--------------------------------------------------\n  The execution plan of this statement can be improved by creating one or more\n  indices.\n \n  Recommendation (estimated benefit: 99.99%)\n  ------------------------------------------\n  - Consider running the Access Advisor to improve the physical schema design\n    or creating the recommended index.\n    create index USERS.IDX$$_17C0B0001 on\n    USERS.CUSTOMERS(\"SIGN_DATE\");\n\t\n3- SQL Profile Finding (see explain plans section below)\n--------------------------------------------------------\n  A potentially better execution plan was found for this statement.\n\n  Recommendation (estimated benefit: 68.27%)\n  ------------------------------------------\n  - Consider accepting the recommended SQL profile.\n    execute dbms_sqltune.accept_sql_profile(task_name =&gt;\n            'SQL_TUNNING_TASK_5t5mxfm0ph3n0', task_owner =&gt; 'SYS', replace =&gt;\n            TRUE);\n\n-------------------------------------------------------------------------------\nEXPLAIN PLANS SECTION\n-------------------------------------------------------------------------------\n\n1- Original With Adjusted Cost\n------------------------------\nPlan hash value: 321555184\n\n--------------------------------------------------------------------------------\n| Id  | Operation            | Name             | Rows  | Bytes | Cost (%CPU)| T\n--------------------------------------------------------------------------------\n|   0 | SELECT STATEMENT     |                  |     6 |   330 |    19   (0)| 0\n|   1 |  PX COORDINATOR      |                  |       |       |            |\n|   2 |   PX SEND QC (RANDOM)| :TQ10000         |     6 |   330 |    19   (0)| 0\n|   3 |    PX BLOCK ITERATOR |                  |     6 |   330 |    19   (0)| 0\n|*  4 |     TABLE ACCESS FULL| CUSTOMERS |     6 |   330 |    19   (0)| 0\n--------------------------------------------------------------------------------\n\nPredicate Information (identified by operation id):\n---------------------------------------------------\n\n   4 - filter(\"TR\".\"SIGN_DATE\"=TO_DATE(' 2020-12-30 00:00:00', 'syyyy-mm-dd')\n\n2- Using SQL Profile\n--------------------\nPlan hash value: 3378393080\n\n--------------------------------------------------------------------------------\n| Id  | Operation                           | Name               | Rows  | Bytes\n--------------------------------------------------------------------------------\n|   0 | SELECT STATEMENT                    |                    |     6 |   330\n|   1 |  PARTITION RANGE SINGLE             |                    |     6 |   330\n|   2 |   INLIST ITERATOR                   |                    |       |\n|   3 |    TABLE ACCESS BY LOCAL INDEX ROWID| CUSTOMERS   |     6 |   330\n|*  4 |     INDEX RANGE SCAN                | INX_CUSTOMERS_1 |     1 |\n--------------------------------------------------------------------------------\n\nPredicate Information (identified by operation id):\n---------------------------------------------------\n\n   4 - access(\"TR\".\"SIGN_DATE\"=TO_DATE(' 2020-12-30 00:00:00', 'syyyy-mm-dd')\n        \n\n-------------------------------------------------------------------------------\n\nPL\/SQL procedure successfully completed\n<\/code><\/pre>\n\n\n\n<p>Finally, to delete the task or see what state it is in, execute the following:<\/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=\"\" data-no-translation=\"\" data-no-auto-translation=\"\">--SELECT task_name, status FROM dba_advisor_log WHERE task_name = 'SQL_TUNNING_TASK_5t5mxfm0ph3n0';\n execute dbms_sqltune.drop_tuning_task('SQL_TUNNING_TASK_5t5mxfm0ph3n0');<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Sources:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/database\/121\/TGSQL\/tgsql_sqltune.htm#TGSQL540\" target=\"_blank\" rel=\"noreferrer noopener\">Analyzing SQL with SQL Tuning Advisor<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Many times we will hear that suddenly a query that was running fast suddenly started to run slowly or that a query is running very slowly for no reason. The easiest way to find out what is wrong and solve it is by running Oracle&#039;s SQL Tuning Advisor. When running it for the specific query, it collects [\u2026]<\/p>","protected":false},"author":1,"featured_media":704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,16],"tags":[29,5,48,30,39],"class_list":["post-2896","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-oracle-db","tag-databases","tag-oracle-database","tag-performance_tuning","tag-rdbms","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr<\/title>\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.dataplatform.gr\/en\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03c4\u03cd\u03c7\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03ba\u03bf\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03cc\u03c4\u03b9 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03ad\u03bd\u03b1 query \u03c0\u03bf\u03c5 \u03c0\u03ae\u03b3\u03b1\u03b9\u03bd\u03b5 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03ac\u03c1\u03c7\u03b9\u03c3\u03b5 \u03bd\u03b1 \u03b1\u03c1\u03b3\u03b5\u03af \u03ae \u03cc\u03c4\u03b9 \u03ad\u03bd\u03b1 query \u03c0\u03b7\u03b3\u03b1\u03af\u03bd\u03b5\u03b9 \u03b1\u03b4\u03b9\u03ba\u03b9\u03bf\u03bb\u03cc\u03b3\u03b7\u03c4\u03b1\u00a0\u03c0\u03bf\u03bb\u03cd \u03b1\u03c1\u03b3\u03ac. \u039f \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b9 \u03c6\u03c4\u03b1\u03af\u03b5\u03b9 \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03c4\u03bf \u03bb\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03c4\u03bf\u03c5 SQL Tuning Advisor \u03c4\u03b7\u03c2 Oracle. \u039a\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03c4\u03bf\u03c5 \u03b3\u03b9\u03b1 \u03c4\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03bf query \u03c3\u03c5\u03bb\u03bb\u03ad\u03b3\u03b5\u03b9 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-22T05:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-15T11:35:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor)\",\"datePublished\":\"2021-03-22T05:00:00+00:00\",\"dateModified\":\"2025-01-15T11:35:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/\"},\"wordCount\":79,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"keywords\":[\"Databases\",\"Oracle Database\",\"Performance Tuning\",\"RDBMS\",\"SQL\"],\"articleSection\":[\"Databases\",\"Oracle Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"datePublished\":\"2021-03-22T05:00:00+00:00\",\"dateModified\":\"2025-01-15T11:35:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_oracle.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Database\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/databases\\\/oracle-db\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr","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.dataplatform.gr\/en\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr","og_description":"\u03a0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03c6\u03bf\u03c1\u03ad\u03c2 \u03b8\u03b1 \u03c4\u03cd\u03c7\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03ba\u03bf\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03cc\u03c4\u03b9 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03ad\u03bd\u03b1 query \u03c0\u03bf\u03c5 \u03c0\u03ae\u03b3\u03b1\u03b9\u03bd\u03b5 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1 \u03be\u03b1\u03c6\u03bd\u03b9\u03ba\u03ac \u03ac\u03c1\u03c7\u03b9\u03c3\u03b5 \u03bd\u03b1 \u03b1\u03c1\u03b3\u03b5\u03af \u03ae \u03cc\u03c4\u03b9 \u03ad\u03bd\u03b1 query \u03c0\u03b7\u03b3\u03b1\u03af\u03bd\u03b5\u03b9 \u03b1\u03b4\u03b9\u03ba\u03b9\u03bf\u03bb\u03cc\u03b3\u03b7\u03c4\u03b1\u00a0\u03c0\u03bf\u03bb\u03cd \u03b1\u03c1\u03b3\u03ac. \u039f \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03bf\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c2 \u03bd\u03b1 \u03b2\u03c1\u03bf\u03cd\u03bc\u03b5 \u03c4\u03b9 \u03c6\u03c4\u03b1\u03af\u03b5\u03b9 \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03c4\u03bf \u03bb\u03cd\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03c4\u03bf\u03c5 SQL Tuning Advisor \u03c4\u03b7\u03c2 Oracle. \u039a\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03c4\u03bf\u03c5 \u03b3\u03b9\u03b1 \u03c4\u03bf \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03bf query \u03c3\u03c5\u03bb\u03bb\u03ad\u03b3\u03b5\u03b9 [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-03-22T05:00:00+00:00","article_modified_time":"2025-01-15T11:35:22+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor)","datePublished":"2021-03-22T05:00:00+00:00","dateModified":"2025-01-15T11:35:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/"},"wordCount":79,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","keywords":["Databases","Oracle Database","Performance Tuning","RDBMS","SQL"],"articleSection":["Databases","Oracle Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/","url":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/","name":"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor) - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","datePublished":"2021-03-22T05:00:00+00:00","dateModified":"2025-01-15T11:35:22+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_oracle.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/pos-tha-veltiosoyme-ena-query-poy-trechei-se-v\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.dataplatform.gr\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Oracle Database","item":"https:\/\/www.dataplatform.gr\/category\/databases\/oracle-db\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03b8\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03b1\u03c0\u03cc\u03b4\u03bf\u03c3\u03b7 \u03b5\u03bd\u03cc\u03c2 query \u03c0\u03bf\u03c5 \u03c4\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c3\u03b5 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c4\u03b7\u03c2 Oracle (SQL Tuning Advisor)"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=2896"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2896\/revisions"}],"predecessor-version":[{"id":5854,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/2896\/revisions\/5854"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/704"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=2896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=2896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=2896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}