Information générale
Forum:
Microsoft SQL Server
Titre:
Performance of Select setup
I was e-mailed this from a QA person on a project I'm working on. They use SQL7. I have never setup my Selects like this, plus I don't use standard selects I use ANSI Joins. Is there any validity to the below statement.
"I just would like to make a friendly reminder for all developers in order to
increase performance.
In the Where clause of the Select Statement we should start with Boolean
expressions instead of joins to reduce searching time.
WHERE
i.ob_type = '1' AND
b.ghost_card_flag = 0 AND
h.card_id = g.card_id AND
b.card_id = c.card_id
Regards"
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