INNER JOIN or Sub-query? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

INNER JOIN or Sub-query?

Message

De

20/03/2006 10:43:23

Fabio Lunardon
Lunacom
Marostica, Italie

À

20/03/2006 10:33:15

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: INNER JOIN or Sub-query?

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP2

Database:

Visual FoxPro

Divers

Thread ID:

01105835

Message ID:

01105854

Vues:

17

>>join can to be faster but it is formally incorrect.
>>if you use c_temp here once only, doesn't index it, vfp does this in a faster way
>
>Are you sure I don't have to index this c_temp cursor? I added the index today in the morning, it seemed to degrade performance...
>
>Thanks.

VFP build a temp index on the fly.

What is RECCOUNT("c_temp") ?

Why have you cUserId and iUserId ?

Click here to load this message in the networking platform