Fetching from a cluster table is usually slow. If you want a better performance, try to select it from its corresponding transparent tables. Like BSID, BSAD, etc.
You might end up having more select clauses, because all the fields u r interested in, may not be in one table. But the performance will be better.