-
Is there a benefit to having one table per tablespace on the same disk, instead of having multiple tables in one tablespace. Is their a performance issue with this. thanks
-
-
Performance issues related to No of Tables in a TBS is not defined as such. It might be conceptually wrong to ask the question but ..
TBS has Datafile that could be spread on to differen Disks.
There might be some performance degradation if a Table in a TBS is spread onto too many datafiles.
-
Originally posted by patnams
There might be some performance degradation if a Table in a TBS is spread onto too many datafiles.
How so?
Jeff Hunter
-
Originally posted by patnams
There might be some performance degradation if a Table in a TBS is spread onto too many datafiles.
you mean the other way round?
-
What I meant was that when a table exists on multiple datafiles, it also means that it is fragmented that many times as the number of disks.
(both Clustering and Indexed Organized Tables are based on concept of trying to storing data in nearly one physical location )
-
Originally posted by patnams
What I meant was that when a table exists on multiple datafiles, it also means that it is fragmented that many times as the number of disks.
I definitely disagree.
Just because a table is in multiple extents does not mean it is fragmented.
In addition, when you have multiple devices spinning to retrieve your data you will get much better performance then when everything is on one device.
Jeff Hunter
-
Originally posted by patnams
What I meant was that when a table exists on multiple datafiles, it also means that it is fragmented that many times as the number of disks.
(both Clustering and Indexed Organized Tables are based on concept of trying to storing data in nearly one physical location )
seems like you still belive this old myth of multiple extents is bad....
-
With so may moving parts available these, it is surely based on old myth.
I've done a lot of experimenting with fragmentation before, but never could really attribute performance to fragmentation.
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
|