Information générale
Catégorie:
Codage, syntaxe et commandes
George,
Pardon my English, but that would be awfully stupid of SQL - to run the Date function for every record in the input. What makes you so sure it would do so??
Enquiring minds need to know.
regards,
Jim N
>>Is there any optimization difference in the following:
>>
>>SELECT FIELD FROM TABLE WHERE FIELDDATE=DATE() INTO CURSOR TEMP
>>
>>OR
>>
>>ldDate=DATE()
>>SELECT FIELD FROM TABLE WHERE FIELDDATE=ldDate INTO CURSOR TEMP
>
>Michel,
>
>I'm not sure about differences in optimization, but the latter query should execute faster. The reason being that the date function will have to be called and it will have to return its value for every record in the table. In the latter case, it simply a straight comparison.
>
>George
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement