Hi,
I am reading from a oracle table which not partitioned.But if i use PartitionTable option in Oracle enterprise stage to the read this unpartitioend table i see the performance improvement.
Can any one pelase explain me when we need to apply partitiontable option.What is the use of this option even if table is not partitioned.
Thanks
dstest
Regarding PartitionTable Option in oracle Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
can i multilple tables in this option
Hi ,
I would want to make the ORACLE enterprise stage to read in parallel from the source. But by default it is sequential. But i have a user-defined SQL which has many table joined.
SO if i include all these tables used in the SQL in the partition option would all of them read in parallel ?
I would want to make the ORACLE enterprise stage to read in parallel from the source. But by default it is sequential. But i have a user-defined SQL which has many table joined.
SO if i include all these tables used in the SQL in the partition option would all of them read in parallel ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: