Hi!
We group tables in tablespace by logical groups. For example, all common
tables (like currency, country, ...) are in one tablespace. If we have
large tables that need to be fast we usually use range partitioning
across multiple tablespaces.
Best regards,
Kovi
mvsmsh pravi:
Hi , all
We have hundreds of tables in on tablespace ,
but I'm planning to change as one table per one tablespace. .
I wonder how other shops does ?
Are there any special reasons in UDB
keeping multiple tables in one tablesapce ?
Regards
Myoungsoo
Ex M/F DBA
--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-