{"id":1680,"date":"2015-07-09T22:21:56","date_gmt":"2015-07-10T01:21:56","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1680"},"modified":"2015-07-09T22:21:56","modified_gmt":"2015-07-10T01:21:56","slug":"ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/","title":{"rendered":"OCM 11g Preparation &#8211; Administer and tune schema object to support various access methods"},"content":{"rendered":"<p>Access Methods\u00a0(or Paths) are something totally related to the optimizer.<\/p>\n<p>So, what you should study here are the access methods that are possible inside Oracle for either Tables, B-Tree Indexes, Bitmap Indexes or Clusters:<\/p>\n<ul>\n<li>Full Table Scans<\/li>\n<li>Table Access by Rowid<\/li>\n<li>Sample Table Scans<\/li>\n<li>Index Unique Scans<\/li>\n<li>Index Range Scans<\/li>\n<li>Index Full Scans<\/li>\n<li>Index Fast Full Scans<\/li>\n<li>Index Skip Scans<\/li>\n<li>Index Join Scans<\/li>\n<li>Bitmap Index Single Value<\/li>\n<li>Bitmap Index Range Scans<\/li>\n<li>Bitmap Merge<\/li>\n<li>Bitmap Index Range Scans<\/li>\n<li>Cluster Scans<\/li>\n<li>Hash Scans<\/li>\n<\/ul>\n<p>You will only be good in this topic with practice. In my opinion, studying explain plans and access paths will only give you theory concepts (that serves for almost nothing in the OCM exam). Practice with daily work is the best approach for this topic.<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Performance Tuning Guide -&gt; 11 The Query Optimizer<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 11g Preparation\" href=\"\/?page_id=923\">Main OCM 11g Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1680 jlk' href='javascript:void(0)' data-task='like' data-post_id='1680' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1680 lc'>+3<\/span><\/a><\/div><\/div> <div class='status-1680 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Access Methods\u00a0(or Paths) are something totally related to the optimizer. So, what you should study here are the access methods that are possible inside Oracle for either Tables, B-Tree Indexes, Bitmap Indexes or Clusters: Full Table Scans Table Access by Rowid Sample Table Scans Index Unique Scans Index Range Scans Index Full Scans Index Fast &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1680","post","type-post","status-publish","format-standard","hentry","category-ocm11g-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 11g Preparation - Administer and tune schema object to support various access methods - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Administer and tune schema object to support various access methods for Oracle OCM 11g Certification\" \/>\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.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 11g Preparation &#8211; Administer and tune schema object to support various access methods\",\"datePublished\":\"2015-07-10T01:21:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/\"},\"wordCount\":156,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 11g Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/\",\"name\":\"OCM 11g Preparation - Administer and tune schema object to support various access methods - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2015-07-10T01:21:56+00:00\",\"description\":\"Administer and tune schema object to support various access methods for Oracle OCM 11g Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2015\\\/07\\\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 11g Preparation - Administer and tune schema object to support various access methods\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OCM 11g Preparation - Administer and tune schema object to support various access methods - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Administer and tune schema object to support various access methods for Oracle OCM 11g Certification","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.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 11g Preparation &#8211; Administer and tune schema object to support various access methods","datePublished":"2015-07-10T01:21:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/"},"wordCount":156,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 11g Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/","url":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/","name":"OCM 11g Preparation - Administer and tune schema object to support various access methods - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2015-07-10T01:21:56+00:00","description":"Administer and tune schema object to support various access methods for Oracle OCM 11g Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2015\/07\/ocm-11g-preparation-administer-and-tune-schema-object-to-support-various-access-methods\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 11g Preparation - Administer and tune schema object to support various access methods"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=1680"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1680\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}