| Partitioning of Tables [message #52533] |
Mon, 29 July 2002 00:41  |
kalpaj
Messages: 3
Registered: July 2002
|
Junior Member |
|
|
hi
we have oracle server.
It take lots of time to genarate even small report.
most of our report comes from few transaction tables.
that is huge. i want to partitin that all tables.
I want to know
1. Any changes i have to done from frontend side
from where insert statments.
like : INSERT INTO sales PARTITION (oct97)
VALUES (...);
2. what change i have to do in index
I will be greatfull if any body will help in this
matter. i am very new ad a oracle DBA.
kalpaj
|
|
|
|
| Re: Partitioning of Tables [message #52535 is a reply to message #52533] |
Mon, 29 July 2002 04:45  |
Depa
Messages: 30
Registered: June 2002
|
Member |
|
|
if you partition a table,
the insert statement need not be changed.It is like usual insert statement.
oracle will take care of the insertion into appropriate partitions.
When you partition a table, then any indexes created on that table will also be partitioned
|
|
|
|
| Re: Partitioning of Tables [message #52539 is a reply to message #52535] |
Mon, 29 July 2002 06:52 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Kalpaj, Deepa,
It is not true that 'When you partition a table, then any indexes created on that table will also be partitioned'.
You need to create a partioned index or else you can make a normal index also. Check out diff types of partitioned indexes:
local prefixed index
non-local prefixed index
global index
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
