Does anyone know whether ASE 12.5 allows one to use the union operator
in a view and if not, how to get around this limiation?

Femi Anthony

femi@cnet.com (Olufemi Anthony) wrote in message news:<53ba6ff2.0312171319.301a5dcc@posting.google. com>...
> Does anyone know whether ASE 12.5 allows one to use the union operator
> in a view and if not, how to get around this limiation?
>
> Femi Anthony

ASE 12.5.x does allow unions in views.

-bret

Bret Halford wrote:
> femi@cnet.com (Olufemi Anthony) wrote in message news:<53ba6ff2.0312171319.301a5dcc@posting.google. com>...
>> Does anyone know whether ASE 12.5 allows one to use the union operator
>> in a view and if not, how to get around this limiation?
>>
>> Femi Anthony
>
> ASE 12.5.x does allow unions in views.
>
> -bret

There are few surprises when doing this, for example sum() + group by does
not use indexes...

Toni

> There are few surprises when doing this, for example sum() + group by does
> not use indexes...

Not true. I just created such a view, with a sum() in it, and it used
the index I created for it. Perhaps there is/was something in your
sql, indexes, or data that prevented using an index in your particular
case. This is not, however, the general case.

> There are few surprises when doing this, for example sum() + group by does
> not use indexes...

Not true. If an index is available and useable by the server, it will
use it. I just tried it and it did!

Sorry for the double post.

I have used, it works. But there was page corruption happening during
accessing the view. When contacted with sybase, they recomended to use
ESD3 or later patch which solves the problem.
-Zia