Tablespace Recommendations

[dbomrrsm]

I have recently read that in a reporting system where two tables are frequently joined together as part of queries they should be stored within seperate tablespaces.

This was in a document under a section entitled:

Tablespace Recommendations

Can anyone throw any light on why this sould be done ?

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[Dagon]

The reason would be to reduce disk contention. If the two tables are both on the same disk and queries are always having to access both of them, that is doubling the amount of I/O on that disk. It therefore makes sense to have them on different devices. With newer technologies like disk striping, a lot of this sort of advice is redundant.

 

[dbomrrsm]

Dagon

Thanks for the explanation.


[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]