4
Reply

Does Cast() and Convert() make query performance low??

ajaz N

ajaz N

Jan 23 2015 7:53 AM
803
In my query i have cast and convert functions,which made my query run for long time.
When i removed those functions and replaced them with day/month/year functions and concatenated them for getting a format of date
which took less time.
Is this because convert() or cast() takes more execution time ?
 
Thank you
in advance

Answers (4)