| partitioning a non-partitioned table [message #304077] |
Mon, 03 March 2008 23:59  |
M.Shakeel Azeem
Messages: 226
Registered: September 2006
|
Senior Member |
|
|
Dear All,
I had a non-partitioned table with millions of record which getting bigger and bigger so the queries on this particular table are getting slower & slower
So v have decided to partition this table ,this table have a date column (e.g. start_date) and according to our environment we decided to create range partion based on the column start_date
My question is
can v create partitions based on a non-partioned table without creating new table and then move data to new table
i just want to partition my non-partitioned table
please suggest me how to achieve this?
|
|
|
|
|
|
|
|
| Re: partitioning a non-partitioned table [message #305453 is a reply to message #304077] |
Mon, 10 March 2008 16:49  |
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
|
Junior Member |
|
|
hi,
another thing you must see after you partition your table is
that your queries are using the partitioned index - the
start date.
you can check this out very simple by using explain plan and
see on the access to the new parition table which partitions are
been used.
shlomi.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
