On Wednesday 23 July 2003 11:21, Rajesh Kumar Mallah wrote:
Hi ,
I have a view which is a union of select of certain feilds from
indentical tables. The problem is when we query a column on
which index exists exists foreach of the tables does not use the
indexes.
But when we query
Rajesh Kumar Mallah [EMAIL PROTECTED] writes:
I have a view which is a union of select of certain feilds from
indentical tables. The problem is when we query a column on
which index exists exists foreach of the tables does not use the
indexes.
Hard to be certain since you didn't show us the
[EMAIL PROTECTED] writes:
the column 'generated' was timestamp in 2 place and date in 2 place,
i wanted it in my and did a typecasting in the view below
but it suffers from the same problem .
AFAIR it should work if you insert casts into the UNION's member selects.
Maybe you didn't get the