This is a nice tip for a pure SQL enviroment, but I'm not sure how applicable it is for C/Side. Also there can be a trade-off to indexed views. While they can improve read performance on specific queries, this comes at the cost of needing to maintain them during the write process. Overusing/misusing indexed views can be just as bad as not using them.
There are no bugs - only undocumented features.