Simple question about views:
I have a view such as:
create view combo as
select * from table1
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field "id"..
when I do a:
select * from combo where id='value' ;
the system seems to be doing a table scan of one or both tables.. I
can't even do an:
explain select * from combo where field='value' ;
the system seems to hang on the explain. SHOW PROCESSLIST says the
explain is "Sending data ".
Issuing either one of the view components with the where clause
returns results in a fraction of a second (pretty much a full indexed
I know when I used to use Oracle, the where clause would be applied to
all parts of the view, but in this case, I can't even figure out what
MySQL is trying to do.
(I've also tried "UNION ALL" with the same results).
Any suggestions on how to query both tables using the indexed and the
view at the same time? That was my intention.