All indexes are good, right? Wrong.
An index can make a join fly. but it can also slow you down. As I’ve said many times before, most of the time I delete or hide indexes, especially on an Exadata box and add carefully.
However, whilst query performance is helped by an index, and updates too that use a join, the populating of a table is slowed by the use of an index.
For our usage tracing project we are not going to use the BI_PLATFORM table for our use in OBIEE. Therefore we do not need the indexes, so the we are going to drop the primary key on S_NQ_ACCT. To do this first we drop the foreign keys on S_NQ_DB_ACCT and the Summary Advisor.
ALTER TABLE S_NQ_DB_ACCT DROP CONSTRAINT FK_S_NQ_DB_ACCT;
ALTER TABLE S_NQ_SUMMARY_ADVISOR DROP CONSTRAINT FK_S_NQ_SUMMARY_ADVISOR;
Now we can drop the primary key.
ALTER TABLE S_NQ_ACCT DROP CONSTRAINT S_NQ_ACCT_PK.
I am also dropping the NULL constraints, on all the tables.
Now, on with the news…
Blogs of the week
In this 2 Minute Tech Tip, Oracle ACE Director Debra Lilley, Vice President of Cloud Solutions at Certus Solutions, shares information on this special set of mini-sessions presented by other members of the Oracle ACE program.
Dimitri Gielis says, “When you add a region to your page with a couple of sub-regions and you give the parent region the “Carousel Container” template it turns the regions into a carousel, so you can flip between regions.”
See it in action here.
Lou Bushinsky tells us how to:
- Achieve More Completeness and Consistency
- Ensure More Data Accuracy
- Embrace More Quality Data Practices
M&S Consulting start their post by saying, “There are several enterprises that are currently running the Oracle 10g middleware platform for their front-end applications. They have Oracle Portal 10g or prior versions delivering content for their Oracle Forms, Oracle Reports, and Oracle Discoverer based applications, all running on Oracle Application Server (OAS) 10g.”
Nicholas Ribas says, “In the first post of the Oracle BI Cloud Service (BICS) series we reviewed some of its key features. In the following posts, we will explain how the service actually works, starting with the data provisioning. Check out part III of the BICS series in which we will cover how you can model your data in the cloud according to your business requirements.”
Boris Dahav says, “The Customer asked for line breaks in analysis. This was basically covered before here byobiee10grevisited.blogspot.com but I felt it needs some more examples.” See the full blog for more.
Richard Williams says, “This article will cover the steps to migrate the data from a BICS Schema Service Database, to a BICS DBaaS Database. Similar steps could be used to move a database from BICS to on-premise, or from on-premise to a BICS DBaaS instance.”
Kris Rice posted that “A new SQLCL build was just posted go grab it and kick the tires. There are well over 100 bug fixes in there so it’s better than ever. Also there’s some new things.”
- More secure
- REST support
Jeff Smith posted about Oracle Open World:
Y.V RaviKumar posted “In this article, we are creating and configuring two node RAC (Real Application Clusters) setup with container database (CDB) with pluggable database in multitenant environment using Oracle Standard Edition SE2 (184.108.40.206.0)”
Curtis posted a blog all about the plug-in for the Oracle Database Appliance. He also posted a list of articles that relate to installing agents in EM12C (if you don’t know how to do that already).
Download the OpenWorld 2015 ap here.
Vishal Pathak writes a comprehensive blog about toggling the database in OBIEE 11g at runtime. Read the full blog here.
He also links to the video:
This week on LinkedIn
Alexander Hansal asked, What Will #OOW15 Bring for the Siebel Community?
Anmol Kaushik posted OBIEE Horizontal Clustering – DIY Guide – Part 1
This week on Twitter
Perficient&Oracle tweeted OBIEE 220.127.116.11 – BI Publisher Set Up Fails on Windows Server 2012
Videos such as: #Kscope 15: Thats a Wrap Part 2
and Webinar : Best Practices with Oracle BI Financial Analytics