Virtual table as reference data for IN_REFERENCE_COLUMN chec
Posted: Mon Jun 22, 2015 11:29 pm
Is it possible to use an IA virtual table (a three-way join of source data tables) to provide the reference column for an IN_REFERENCE_COLUMN check?
Would the performance of such an approach be better than, or worse than, doing the same join in a view in the source database (which happens to be Netezza)?
Thank you again for your time.
Would the performance of such an approach be better than, or worse than, doing the same join in a view in the source database (which happens to be Netezza)?
Thank you again for your time.