On 02/08/2018 20:50, Keith Medcalf wrote:
In no DBMS known can you index data sourced from multiple tables in the same index -- this applies to "Relational" databases and all other database models (such as pure hierarchical, network, network extended, etc.) In all DBMS systems the contents of the index must be sourced from a single object.
To the best of my (limited) knowledge, Oracle's CLUSTER is the only technique allowing an index to reference rows from several tables. The rows (from source tables) that share the same value of a column are collected into a page, if needed complemented by an overflow chain of pages. Whether the OP is ready to migrate to Oracle is another story!
J-L Hainaut _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
