How can we make index on UDF/ Is there is away to replace table scan on UDF's

• John Paul-702936

  SSCrazy

  Points: 2182

  More actions

  August 7, 2009 at 8:13 am

  #133797

  How can we make index on UDF/ Is there is away to replace table scan on UDF's

  As per the article ,

  UDF as Computed Column

  By Dinesh Priyankara, 2003/06/18 - he mentioned like ..

  But remember, you can make an index on UDF, if it is deterministic.

  How can we index the UDF..

  I am using 3 UDF in one store procedure , which trows table Scan and which is very expensive in terms of execution time ..

  Is any way to aviod /replace Table scan with Seek .. so that the performance of the store procedures increases

  Thanks a lot

• Grant Fritchey

  SSC Guru

  Points: 398909

  More actions

  August 7, 2009 at 8:17 am

  #1036023

  Please don't cross-post. Let's hold the discussion over here.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning