When using the INTERSECT command, does it make a difference in speed if
the big table (many 100,000's of rows) or the small table (100 rows) is
listed first?
INTERSECT BigTable WITH SmallTable FORMING TEMPORARY ResultTable USING
OneColumn
OneColumn is a PK column in BigTable.
SmallTable is a temporary table.
Would it help to add an index to OneColumn in SmallTable, even though
it's only 100 rows?
RB X.5 Enterprise, BTW.
Thanks,
Doug
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
