Hello All,
I know that several rows from a table can be allocated in one single data page, but do you know if several rows from several tables can be allocated in the same database page?.
can i have also several nodes from several indexes in on single index page?
Regards & Thanks,
E.

Depends on what product you are talking about.

With DB2 for z/OS, if you use a "simple" tablespace, you can have multiple tables per data page. This is not supported on segmented or partitioned tablespaces.

With DB2 for Linux, UNIX, and Windows the answer is no, you cannot have multiple tables per data page.

For indexes, the answer is no for either product.