Database DataWarehousing (MOSC)

MOSC Banner

How to best partition a table and how will the query be

edited Nov 5, 2012 4:11AM in Database DataWarehousing (MOSC) 7 commentsAnswered ✓
hi experts.
The developer is asking me how to best partition a table that has 30 millions records daily and how it will be the query.
They say that currently they are querying the column filedate which is a string, and then they look for a substring to look for the data by day. They don't use the index making the process more slow.

They want to create a column named FILEDATE_PARTITION  and this to have a partition by day so to be able to filter by day and using a index so that it can be more efficient.


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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center