{"id":19541,"date":"2024-03-15T19:03:21","date_gmt":"2024-03-15T19:03:21","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/"},"modified":"2024-03-21T15:56:49","modified_gmt":"2024-03-21T15:56:49","slug":"how-can-i-make-newly-added-indexes-in-oracle-take-effect","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/","title":{"rendered":"How can I make newly added indexes in Oracle take effect?"},"content":{"rendered":"<p>To make the newly created index take effect, you need to perform the following steps:<\/p>\n<ol>\n<li>To create an index: use the CREATE INDEX statement to create an index. The syntax is as follows:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> INDEX index_name <span class=\"hljs-keyword\">ON<\/span> table_name (column_name);\r\n<\/code><\/pre>\n<p>index_name is the name of the index, table_name is the name of the table where the index will be created, and column_name is the name of the column to be indexed.<\/p>\n<ol>\n<li>Confirm that the index has been successfully created: You can use the following statement to check if the index has been successfully created:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">SELECT<\/span> index_name <span class=\"hljs-keyword\">FROM<\/span> user_indexes <span class=\"hljs-keyword\">WHERE<\/span> table_name <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'table_name'<\/span>;\r\n<\/code><\/pre>\n<p>&#8220;table_name is the name of the table to be queried.&#8221;<\/p>\n<ol>\n<li>Update statistical information: The performance of indexes depends on the statistical information of the table. You can update the statistical information of the table using the following statement.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">BEGIN<\/span>\r\n    DBMS_STATS.GATHER_TABLE_STATS(<span class=\"hljs-string\">'schema_name'<\/span>, <span class=\"hljs-string\">'table_name'<\/span>);\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<p>In which schema_name is the name of the schema where the table is located, and table_name is the name of the table for which to update statistics.<\/p>\n<ol>\n<li>To force a recompilation of stored procedures and functions: If the created indexes are related to the stored procedures or functions, it may be necessary to force a recompilation of these objects in order to use the new indexes. You can use the following statement to force a recompilation of stored procedures and functions:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">PROCEDURE<\/span> procedure_name COMPILE;\r\n<span class=\"hljs-keyword\">ALTER<\/span> <span class=\"hljs-keyword\">FUNCTION<\/span> function_name COMPILE;\r\n<\/code><\/pre>\n<p>In which, procedure_name refers to the name of the stored procedure, while function_name refers to the name of the function.<\/p>\n<p>Please note that creating indexes can lead to a decrease in the performance of insertions, updates, and deletions, as the database needs to update the indexes every time table data is modified. Therefore, it is important to use indexes carefully and conduct thorough testing and evaluation before creating them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To make the newly created index take effect, you need to perform the following steps: To create an index: use the CREATE INDEX statement to create an index. The syntax is as follows: CREATE INDEX index_name ON table_name (column_name); index_name is the name of the index, table_name is the name of the table where the [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-19541","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can I make newly added indexes in Oracle take effect? - Blog - Silicon Cloud<\/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.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I make newly added indexes in Oracle take effect?\" \/>\n<meta property=\"og:description\" content=\"To make the newly created index take effect, you need to perform the following steps: To create an index: use the CREATE INDEX statement to create an index. The syntax is as follows: CREATE INDEX index_name ON table_name (column_name); index_name is the name of the index, table_name is the name of the table where the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T19:03:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T15:56:49+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"How can I make newly added indexes in Oracle take effect?\",\"datePublished\":\"2024-03-15T19:03:21+00:00\",\"dateModified\":\"2024-03-21T15:56:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\"},\"wordCount\":294,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\",\"name\":\"How can I make newly added indexes in Oracle take effect? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T19:03:21+00:00\",\"dateModified\":\"2024-03-21T15:56:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can I make newly added indexes in Oracle take effect?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can I make newly added indexes in Oracle take effect? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/","og_locale":"en_US","og_type":"article","og_title":"How can I make newly added indexes in Oracle take effect?","og_description":"To make the newly created index take effect, you need to perform the following steps: To create an index: use the CREATE INDEX statement to create an index. The syntax is as follows: CREATE INDEX index_name ON table_name (column_name); index_name is the name of the index, table_name is the name of the table where the [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T19:03:21+00:00","article_modified_time":"2024-03-21T15:56:49+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"How can I make newly added indexes in Oracle take effect?","datePublished":"2024-03-15T19:03:21+00:00","dateModified":"2024-03-21T15:56:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/"},"wordCount":294,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/","name":"How can I make newly added indexes in Oracle take effect? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T19:03:21+00:00","dateModified":"2024-03-21T15:56:49+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-make-newly-added-indexes-in-oracle-take-effect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can I make newly added indexes in Oracle take effect?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=19541"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19541\/revisions"}],"predecessor-version":[{"id":53289,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/19541\/revisions\/53289"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=19541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=19541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=19541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}