topic MV Table in a business schema in Data & Schema Discussions

MV Table in a business schema

lgualco — Wed, 14 Jun 2023 20:38:28 GMT

Dear all,

is it possible to create a MV from two tables in a physical schema and use this MV in the business schema ?

Re: MV Table in a business schema

JoeM — Thu, 15 Jun 2023 18:49:58 GMT

Is the MV you are referring to joining two tables? Yes, once you've created the MV and loaded it, it will be available to be built into a view in the business schema.

Re: MV Table in a business schema

lgualco — Fri, 16 Jun 2023 12:26:51 GMT

yes, it will be a join between two tables and and I don't know if the best practices is to use the join feature or this way (with MV used in the dashboard) is also fine,.

Re: MV Table in a business schema

RADSr — Fri, 16 Jun 2023 17:11:01 GMT

I'd suggest that best practices don't prohibit using an MV this way, but you should default to letting the two source tables ( and join ) do the work if there's not compelling reason to put together the MV.

That said, there *are* compelling modeling reasons that exist ( cardinality mostly ) and there's no runtime penalty for using an MV v. any other Incorta table so use them if you need them.