"Quick Learn": IT tips by experts

Microsoft => SQL Server => Topic started by: kaluahir16 on October 10, 2012, 04:02:54 PM

Title: What is disadvantages of function in where clause of sql query?
Post by: kaluahir16 on October 10, 2012, 04:02:54 PM
SQL Server will not be able to use any index there may be on your date column.
This can kill performance on a large table
Title: Re: What is disadvantages of function in where clause of sql query?
Post by: BhushanShah on October 10, 2012, 08:59:40 PM
are you talking about user defined functions or built in functions of sql server?
Title: Re: What is disadvantages of function in where clause of sql query?
Post by: Ritesh Shah on October 11, 2012, 05:20:38 PM
no matter whether it is UDF or system function but if your index is on column without function and you are having function with column in WHERE or ON clause, you will not get benefit of index