Hi all.
I'd like to understand how partitioning (actually table inheritance) works when
the number of tables grows in the order of thousands.
In my case, all child tables inherit also the indexes from the master
one (as well as constraints).
1. How will change the performances in the case a relevant number of
the child tables (10%) needs to
be included in the actual query? Do the needed time and resource grow
linearly (or what)?
2. How will work a PK on the master table in regards to the child tables?
3. Will a FK reference to the master table's PK be "redirected" to the
proper child table?
--
Vincenzo Romano
NotOrAnd Information Technologies
NON QVIETIS MARIBVS NAVTA PERITVS