Function execution

Hello,
I am trying to optimize a function, and need some
information on functions, can anyone help me out.
1. Is function a compiled object of SQL.
2. If yes how do we recompile it.
Thanks,
ManojManoj,
Are these user defined functions? Or using functions like MAX, MIN, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Function execution

Hello,
I am trying to optimize a function, and need some
information on functions, can anyone help me out.
1. Is function a compiled object of SQL.
2. If yes how do we recompile it.
Thanks,
Manoj
Manoj,
Are these user defined functions? Or using functions like MAX, MIN, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.