Hi All

I recently discovered that views do not use the indexes of the underlying
tables when they are Unions or groups. This explains a performance problem
we have in Crystal reports where we join two views that are both unions of
two other tables. Someone mentioned that Firebird 2 might allow indexes in
these circumstances. Does any one know if that is true?

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd