The underlying table's index on the Name column is not chosen because of low selectivity.

myview cannot be automatically indexed.

myview was defined with the temptable processing algorithm.

Column Name in myview can be indexed if the is_updatable attribute is true.