Subject | Re: Full table scan |
---|---|
Author | semprolbat |
Post date | 2002-06-25T10:56:51Z |
> SELECT *Does not seem to give the wanted effect, even when I switch tables
> FROM SWEDEN
> WHERE (NAME = 'MAGNUS' or 1=0)
from SWEDEN to NORWAY, which of course er mye bedre.
I've come across the PLAN statement, and some testing gave impressive
improvement in execution speed.