On 16 June 2010 19:07, Bryan Montgomery wrote:
> If I do select * from Table_A a, Table_X x where a.id = x.id
> and it only returns 1 or a few rows, should it use an index if I have an
> index built on Table_A using id?
It should because it scans Table_A too.
> Or do I need an index individually
Hello,
A quick question (I think).
If I have Table_A with id integer, val text - and no data.
Table_B inherits from Table_A and has a bunch of data.
Table_C inherits from Table_A and has some data.
Table_X has id integer, someValue integer
If I do select * from Table_A a, Table_X x where a.id = x.
