Query SQL un po' lunga

[computero]

Si potrebbe ottimizzare secondo voi?


<%SQL="SELECT * FROM criticita WHERE area='"& area & "' AND sede='RS'
AND programma='"&programma(0)&"' AND sede='RS'
OR programma='"&programma(1)&"' AND sede='RS'
OR programma='"&programma(2)&"' AND sede='RS'
OR programma='"&programma(3)&"' AND sede='RS'
OR programma='"&programma(4)&"' AND sede='RS'
OR programma='"&programma(5)&"' AND sede='RS' "

rec.Open SQL,conn,1
Totale = rec.RecordCount
rec.Close
Set rec = Nothing
conn.Close
set conn = Nothing %>



grasssie

[willybit]

SQL="SELECT * FROM criticita  WHERE area='"& area & "' AND sede='RS' AND programma IN ('"&programma(0)&"','"&programma(1)&"','"&programma(2)&"','"&programma(3)&"','"&programma(4)&"','"&programma(5)&"')"

[computero]

grazie mille!

Lorenzo