Delete that Index

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;

and

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

1. 12 More Things About Oracle Database 12c at OOW15 | Debra Lilley

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.

2. Report Carousel in APEX 5 UT

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.

3. Disrupting BI Part 3: Visualizing Better Data with Data Quality

 Lou Bushinsky tells us how to:

  • Achieve More Completeness and Consistency
  • Ensure More Data Accuracy
  • Embrace More Quality Data Practices

4. Migrating from Oracle Portal 10g to Oracle Application Express (APEX)

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.”

5. Oracle BI Cloud Service – Part II: Loading Data

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.”

6. OBIEE – Line Breaks

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.

7. Copy Data from BICS Schema Service to BICS DBaaS or on On-Premise DB

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.”

8. SQLCL – More secure, now with REST !

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

9. All Things SQL Developer at Oracle Open World 2015

Jeff Smith posted about Oracle Open World:

10. Creating Real Application Clusters (RAC) using Oracle Standard Edition SE2 (12.1.0.2.0) with Container Database (CDB) with Pluggable Database (PDB) – Multitenant Environment

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 (12.1.0.2.0)”

11. DISCOVERY AND MONITOR ORACLE DATABASE APPLIANCE (#ODA) USING #EM12C

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).

12. OpenWorld 2015 on your smartphone and tablet

Download the OpenWorld 2015 ap here.

13. Toggling the database in OBIEE 11g at runtime

Vishal Pathak writes a comprehensive blog about toggling the database in OBIEE 11g at runtime.  Read the full blog here.

14. Kscope 15 interview and how to stay up to date with EPM?

He says, “I had the honor and privilege to be interviewed by Opal Alapat at Kscope in Hollywood, Florida. Did you know Opal has an excellent blog?”

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 11.1.1.9 – BI Publisher Set Up Fails on Windows Server 2012

Paper.li

Stories from thatjeffsmith.comkpipartners.com and jonathanlewis.wordpress.com

Videos such as: #Kscope 15: Thats a Wrap Part 2

and Webinar : Best Practices with Oracle BI Financial Analytics