从VIEW快速选择，但WHERE导致缓慢

I have quite a complex view, which uses a hierarchy table structure, which uses a hierarchy data type, and returns a lost of locations. Location is the hierarchy table.I have quite a complex view, which uses a hiera