|
|
| Re: Partition vs Cluster table [message #51960 is a reply to message #51959] |
Mon, 24 June 2002 04:13  |
Depa
Messages: 30
Registered: June 2002
|
Member |
|
|
Partition is nothing but dividing single table into multiple member tables With some checkconstraints for each table and can store each member table in a different tablespace for performance problems.
for eg:
sales for jan in 1 table
sales for feb in 1 table
Clustered table -- Two tables having two or more identical fields sharing the same storage space for those fields instead of storing it twice .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
