-
Partitioning Peoplesoft tables
Hi
Has anyone used partitioning in Peoplesoft (v8) tables?
Cheers
-
ps_proj_resourcce an 80gb little bitty table in PS finacials
steve
I'm stmontgo and I approve of this message
-
I have been using Peoplesoft 8.1.4 very extensively for a very big company is US. The DB size is around 600 GB now.
There are about 20 big tables partitioned.
What is up?
Tamil
-
Hi
A collegue is working with Peoplesoft CRM (The old Vantive), there are a couple of tables which are quite big (around 300 million of rows) and we are thinking to use partitions for these tables. What partitioning options did you guys use? Range, Hash?
-
-
it's been a few months but I think we did range by effective date
steve
I'm stmontgo and I approve of this message
-
ok, will have a look at that column
cheers
-
Originally posted by stmontgo
it's been a few months but I think we did range by effective date
steve
range partition by month i beleive on effective date.
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|