Billing and Revenue Management (MOSC)

MOSC Banner

Index on Partitioned Table

edited Apr 12, 2016 3:10AM in Billing and Revenue Management (MOSC) 10 commentsAnswered

We frequently use sql to fetch data from event_t and its ancillary tables for reporting purpose. Over the time our event_t table have grown up to 60 Lakhs records and we refer created_t columns as our criteria to filter records to get our data. These sqls have started to take toll on performance now because of its growing size. I am interested in making a index on event_t table for created_t column.

My questions are

Is there any recommended approach/steps for creating indexes on BRM tables? Please share reference.

How much sample percent i specify while gathering statistics (OR will it automatically gather statistic for the table when index creation sql is executed in SQLPLUS)?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center