ajaz N

ajaz N

  • NA
  • 1
  • 1.2k

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

Jan 23 2015 7:53 AM
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)