03-07-2024 11:59 AM
I recently deployed the MV Assistant in an Incorta Cloud cluster. I only received one recommendation for optimizing a single MV with 16 rows in it. I'm a little skeptical that the default settings of the cluster are perfect for the MVs. I've got about 30 Spark Python MVs in the cluster that have similar code, and a small amount of data (around 2,000 records amongst the MVs).
Are there any known issues that might be contributing to why there aren't more recommendations being generated? I'd be happy to meet with someone to walk through our cluster to figure out if something with the MV Assistant is malfunctioning.