>Hello all,
>what are the disadavntages of using functions like allt(), upper() in where clause of Select sql. I have been told that it is not good to write such funtions in where clause.
>Please help me what are the disadvantage of this functions in where clause?
>thankyou
>john still
Over head will be more. in turn it will be a bit slower. if u have large database, and Query gives large data , then u eperience the problem.
Précédent
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