{"id":278,"date":"2016-07-14T10:51:05","date_gmt":"2016-07-14T08:51:05","guid":{"rendered":"http:\/\/explainit.pl\/wordpress\/?p=278"},"modified":"2016-08-07T00:01:31","modified_gmt":"2016-08-06T22:01:31","slug":"hinty-dla-perspektyw","status":"publish","type":"post","link":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/","title":{"rendered":"Hinty dla perspektyw"},"content":{"rendered":"<p>Hinty (wskaz\u00f3wki) s\u0105 (niestety) do\u015b\u0107 popularnym narz\u0119dziem w r\u0119kach deweloper\u00f3w usi\u0142uj\u0105cych nak\u0142oni\u0107 kosztowy optymalizator zapyta\u0144 do zastosowania wybranego (przez dewelopera) planu wykonania zapytania. Wiele hint\u00f3w wymaga podania nazwy obiektu zapytania (tabeli, indeksu, itp.), w stosunku do kt\u00f3rego chcemy wymusi\u0107 okre\u015blone zachowanie optymalizatora. Co jednak zrobi\u0107 w przypadku, gdy zapytanie operuje na perspektywie, a chcemy u\u017cy\u0107 hintu w stosunku do np. tabeli u\u017cytej <strong>wewn\u0105trz<\/strong> definicji ten perspektywy (oczywi\u015bcie zwykle nie mamy mo\u017cliwo\u015bci ingerowania w definicj\u0119 perspektywy)? Z pomoc\u0105 wtedy przychodzi dobrze udokumentowana mo\u017cliwo\u015b\u0107 zapisania w hincie referencji do bloku zapytania (Query Block). Oto bardzo prosty przyk\u0142ad.<\/p>\n<p>Perspektywa ORDERS_VIEW jest oparta o tabel\u0119 ORDERS_TABLE. Tabela ORDERS_TABLE posiada indeks na kolumnie STATE. Zapytanie do perspektywy ORDERS_VIEW obecnie nie korzysta z indeksu. Celem naszej demonstracji b\u0119dzie zmuszenie zapytania do u\u017cycia indeksu &#8211; poprzez u\u017cycie hintu poza definicj\u0105 perspektywy (bezinwazyjnie).<\/p>\n<p><code>create table orders_table (ordid number(6), state varchar2(20), amount number(8,2));<br \/>\n...insert...dbms_stats...<br \/>\ncreate index order_state_ind on orders_table(state);<br \/>\ncreate view orders_view as select * from orders_table;<br \/>\n<\/code><\/p>\n<p><code>select sum(amount) from orders_view where state='CLOSED';<br \/>\n<\/code><\/p>\n<p><code>| Id\u00a0 | Operation\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 \u00a0\u00a0| Name\u00a0\u00a0 \u00a0 | Rows \u00a0\u00a0| Bytes | Cost (%CPU)| Time |<br \/>\n----------------------------------------------------------------------------<br \/>\n|\u00a0\u00a0 0 | SELECT STATEMENT \u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0 2 (100)|\u00a0\u00a0\u00a0 \u00a0\u00a0|<br \/>\n|\u00a0\u00a0 1 |\u00a0 SORT AGGREGATE \u00a0\u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0 1 |\u00a0\u00a0\u00a0\u00a0 8 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 \u00a0\u00a0|<br \/>\n|*\u00a0 2 | \u00a0\u00a0TABLE ACCESS FULL|ORDERS_TABLE|\u00a0\u00a0 50 |\u00a0\u00a0 400 |\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 (0)|00:01 |<br \/>\n<\/code><\/p>\n<p>Aby mo\u017cliwe by\u0142o odwo\u0142anie si\u0119 do tabeli ukrytej wewn\u0105trz definicji perspektywy musimy zna\u0107 nazw\u0119 tzw. bloku zapytania (Query Block), kt\u00f3ry reprezentuje definicj\u0119 perspektywy. Mo\u017cna to osi\u0105gn\u0105\u0107 na dwa sposoby &#8211; nadaj\u0105c t\u0119 nazw\u0119 jawnie za pomoc\u0105 hintu QB_NAME() lub podgl\u0105daj\u0105c w planie wykonania zapytania nazw\u0119 wygenerowan\u0105 automatycznie przez optymalizator zapyta\u0144. Skorzystajmy z tego drugiego sposobu &#8211; zauwa\u017cmy, \u017ce konieczne jest wy\u015bwietlenie planu wykonania w formie rozwini\u0119tej (&#8222;ALL&#8221;).<\/p>\n<p><code>select sum(amount) from orders_view where state='CLOSED';<br \/>\nselect * from table (dbms_xplan.display_cursor(null,null,'ALL'));<br \/>\n...<br \/>\n--------------------------------------------------------------------------<br \/>\n| Id\u00a0 | Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Name\u00a0\u00a0 \u00a0 \u00a0| Rows | Bytes| Cost (%CPU)| Time |<br \/>\n--------------------------------------------------------------------------<br \/>\n|\u00a0\u00a0 0 | SELECT STATEMENT\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0 \u00a02 (100)|\u00a0 \u00a0\u00a0\u00a0\u00a0|<br \/>\n|\u00a0\u00a0 1 |\u00a0 SORT AGGREGATE\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0|\u00a0\u00a0\u00a0 1 |\u00a0\u00a0\u00a0 8 |\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 \u00a0\u00a0\u00a0\u00a0|<br \/>\n|*\u00a0 2 |\u00a0\u00a0 TABLE ACCESS FULL|ORDERS_TABLE|\u00a0 50 |\u00a0 400 |\u00a0\u00a0\u00a0 \u00a02\u00a0\u00a0 (0)| 00:01|<br \/>\n...<br \/>\nQuery Block Name \/ Object Alias (identified by operation id):<br \/>\n-------------------------------------------------------------<br \/>\n1 - SEL$F5BB74E1<br \/>\n2 - SEL$F5BB74E1 \/ ORDERS_TABLE@<strong>SEL$2<\/strong><br \/>\n...<br \/>\n<\/code><\/p>\n<p>W sekcji &#8222;Query Block Name&#8221; widzimy nazw\u0119 bloku zapytania, w kt\u00f3rym znajduje si\u0119 referencja do tabeli ORDERS_TABLE &#8211; jest to <strong>&#8222;SEL$2&#8221;<\/strong>. Mo\u017cemy teraz pos\u0142u\u017cy\u0107 si\u0119 t\u0105 nazw\u0105 w tre\u015bci hintu umieszczonego w naszym zapytaniu operuj\u0105cym na perspektywie. Istniej\u0105 dwie formy jej zapisu: nazwa bloku zapytania umieszczona jako pierwszy argument hintu poprzedzona symbolem &#8222;@&#8221; lub nazwa bloku zapytania do\u0142\u0105czona do nazwy tabeli, r\u00f3wnie\u017c po znaku &#8222;@&#8221;.<\/p>\n<p><code>select \/*+ INDEX(@SEL$2 ORDERS_TABLE ORDER_STATE_IND)*\/ sum(amount)<br \/>\nfrom orders_view where state='CLOSED';<br \/>\nselect \/*+ INDEX(ORDERS_TABLE@SEL$2 ORDER_STATE_IND)*\/ sum(amount)<br \/>\nfrom orders_view where state='CLOSED';<br \/>\nselect * from table (dbms_xplan.display_cursor(null,null,'ALL'));<br \/>\n...<br \/>\n|Id| Operation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|Name\u00a0\u00a0\u00a0 | Rows\u00a0 \u00a0\u00a0| Bytes | Cost (%CPU)|<br \/>\n-----------------------------------------------------------------------------------<br \/>\n| 0| SELECT STATEMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0|\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0 2 (100)|<br \/>\n| 1|\u00a0 SORT AGGREGATE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a01 |\u00a0\u00a0\u00a0 8 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<br \/>\n| 2|\u00a0\u00a0 TABLE ACCESS BY INDEX ROWID BATCHED |ORDERS_TABLE|\u00a0 50 |\u00a0 400 |\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a02 (0)|<br \/>\n|*3|\u00a0\u00a0\u00a0 INDEX RANGE SCAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0|ORDER_STATE_IND|50|\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 (0)|<br \/>\n<\/code><\/p>\n<p>W ten oto prosty spos\u00f3b udaje si\u0119 bezinwazyjnie nak\u0142oni\u0107 zapytanie w definicji perspektywy do u\u017cycia wskazanego indeksu.<\/p>\n<p>Standardowa dokumentacja:<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements006.htm#SQLRF00219\">https:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements006.htm#SQLRF00219<\/a><\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements006.htm#BABJIFFH\">https:\/\/docs.oracle.com\/database\/121\/SQLRF\/sql_elements006.htm#BABJIFFH<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hinty (wskaz\u00f3wki) s\u0105 (niestety) do\u015b\u0107 popularnym narz\u0119dziem w r\u0119kach deweloper\u00f3w usi\u0142uj\u0105cych nak\u0142oni\u0107 kosztowy optymalizator zapyta\u0144 do zastosowania wybranego (przez dewelopera) planu wykonania zapytania. Wiele hint\u00f3w wymaga podania nazwy obiektu zapytania (tabeli, indeksu, itp.), w stosunku do kt\u00f3rego chcemy wymusi\u0107 okre\u015blone zachowanie optymalizatora. Co jednak zrobi\u0107 w przypadku, gdy zapytanie operuje na perspektywie, a chcemy u\u017cy\u0107 <a href=\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Hinty dla perspektyw<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[9],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hinty dla perspektyw - Explain IT<\/title>\n<meta name=\"description\" content=\"Hinty dla perspektyw\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hinty dla perspektyw - Explain IT\" \/>\n<meta property=\"og:description\" content=\"Hinty dla perspektyw\" \/>\n<meta property=\"og:url\" content=\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\" \/>\n<meta property=\"og:site_name\" content=\"Explain IT\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-14T08:51:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-08-06T22:01:31+00:00\" \/>\n<meta name=\"author\" content=\"Maciej Zakrzewicz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maciej Zakrzewicz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\"},\"author\":{\"name\":\"Maciej Zakrzewicz\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219\"},\"headline\":\"Hinty dla perspektyw\",\"datePublished\":\"2016-07-14T08:51:05+00:00\",\"dateModified\":\"2016-08-06T22:01:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\"},\"wordCount\":358,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\"},\"keywords\":[\"hinty\"],\"articleSection\":[\"Oracle Database\"],\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\",\"url\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\",\"name\":\"Hinty dla perspektyw - Explain IT\",\"isPartOf\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#website\"},\"datePublished\":\"2016-07-14T08:51:05+00:00\",\"dateModified\":\"2016-08-06T22:01:31+00:00\",\"description\":\"Hinty dla perspektyw\",\"breadcrumb\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/explainit.pl\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hinty dla perspektyw\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#website\",\"url\":\"https:\/\/explainit.pl\/wordpress\/\",\"name\":\"Explain IT\",\"description\":\"Autorska pracownia doradztwa i szkole\u0144 IT - Maciej Zakrzewicz - szkolenia, ekspertyzy, wdro\u017cenia. Technologie Oracle, PostgreSQL, MySQL.\",\"publisher\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/explainit.pl\/wordpress\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\",\"name\":\"Explain IT\",\"url\":\"https:\/\/explainit.pl\/wordpress\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png\",\"contentUrl\":\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png\",\"width\":196,\"height\":64,\"caption\":\"Explain IT\"},\"image\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219\",\"name\":\"Maciej Zakrzewicz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g\",\"caption\":\"Maciej Zakrzewicz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hinty dla perspektyw - Explain IT","description":"Hinty dla perspektyw","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:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/","og_locale":"pl_PL","og_type":"article","og_title":"Hinty dla perspektyw - Explain IT","og_description":"Hinty dla perspektyw","og_url":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/","og_site_name":"Explain IT","article_published_time":"2016-07-14T08:51:05+00:00","article_modified_time":"2016-08-06T22:01:31+00:00","author":"Maciej Zakrzewicz","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Maciej Zakrzewicz","Szacowany czas czytania":"3 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#article","isPartOf":{"@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/"},"author":{"name":"Maciej Zakrzewicz","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219"},"headline":"Hinty dla perspektyw","datePublished":"2016-07-14T08:51:05+00:00","dateModified":"2016-08-06T22:01:31+00:00","mainEntityOfPage":{"@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/"},"wordCount":358,"commentCount":0,"publisher":{"@id":"https:\/\/explainit.pl\/wordpress\/#organization"},"keywords":["hinty"],"articleSection":["Oracle Database"],"inLanguage":"pl-PL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/","url":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/","name":"Hinty dla perspektyw - Explain IT","isPartOf":{"@id":"https:\/\/explainit.pl\/wordpress\/#website"},"datePublished":"2016-07-14T08:51:05+00:00","dateModified":"2016-08-06T22:01:31+00:00","description":"Hinty dla perspektyw","breadcrumb":{"@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/explainit.pl\/wordpress\/2016\/07\/14\/hinty-dla-perspektyw\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/explainit.pl\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Hinty dla perspektyw"}]},{"@type":"WebSite","@id":"https:\/\/explainit.pl\/wordpress\/#website","url":"https:\/\/explainit.pl\/wordpress\/","name":"Explain IT","description":"Autorska pracownia doradztwa i szkole\u0144 IT - Maciej Zakrzewicz - szkolenia, ekspertyzy, wdro\u017cenia. Technologie Oracle, PostgreSQL, MySQL.","publisher":{"@id":"https:\/\/explainit.pl\/wordpress\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/explainit.pl\/wordpress\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Organization","@id":"https:\/\/explainit.pl\/wordpress\/#organization","name":"Explain IT","url":"https:\/\/explainit.pl\/wordpress\/","logo":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/","url":"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png","contentUrl":"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png","width":196,"height":64,"caption":"Explain IT"},"image":{"@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219","name":"Maciej Zakrzewicz","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g","caption":"Maciej Zakrzewicz"}}]}},"_links":{"self":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/278"}],"collection":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/comments?post=278"}],"version-history":[{"count":10,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/278\/revisions"}],"predecessor-version":[{"id":313,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/278\/revisions\/313"}],"wp:attachment":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/media?parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/categories?post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/tags?post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}