General information
Category:
Coding, syntax & commands
Hi Tore,
sorry for my wrong moves, anyway i forgot to set exact on.
thanks for all the tips and guidance.
God Bless All,
Ryan.
Hi Ryan,
PLease don't make a new thread unless it is a NEW thread! You have already got many tips, which are very good in deed.
1. Drop the ALLTRIM, it is not optimizable. Unless you have an index on ALLTRIM, which you must not use unless you love to take risks!!!!!
2. replace the == with = and set exact on in stead
Remember you must have an index on the clause before = in the the where statements.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only