R
r4zSS
Guest
I wonder how exactly the "queries" for each and first work.
lets say I have some tables A, B, C and D.
How many records will I find if I use sth like:
1.
1*|C|*1? [assuming there will be C that has some relation with B, etc]
And then I have sth like this:
How can I make sure to have the same complexity after this change? (B has now relation with A and there will be some where statements) Will it be |A|1|C|*1? And If I want to have the same complexity as before is there anything I can add there?
Continue reading...
lets say I have some tables A, B, C and D.
How many records will I find if I use sth like:
1.
Code:
first B,
each C,
first D:
<block>
end.
1*|C|*1? [assuming there will be C that has some relation with B, etc]
And then I have sth like this:
Code:
for each A,
first B,
/*-----------------------*/
each C,
first D:
<block>
end.
How can I make sure to have the same complexity after this change? (B has now relation with A and there will be some where statements) Will it be |A|1|C|*1? And If I want to have the same complexity as before is there anything I can add there?
Continue reading...