Someday i will ask some question that will makes you think a little
more. You'll see.
I will populate the tables and redo the explain.
Thanks dudes!!
Gerardo
Gerardo Herzig <[EMAIL PROTECTED]> writes:
Watch the last row of the explain command. It makes a sequential scan on the pages table,
like it is not using the index on the "id" field.
The result itself is OK, but i will populate the tables so i think that later
that sequential scan would be a problem.
Why do you think that the plans won't change when the tables get bigger?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend