How to improve performance on a non clustered index seek

How many records do you have?

Can you provide the select statement?

please provide more information.

It seems that you have an optimized query, it is seeking the records

show your query with table structure

Total results count :> 51

Not fetching all columns

am calling some User defined fuctions in select statements

is it because of that

If records are coming in 1 min then it will depends on multiple factors.

1.How many records in table.

2. Are you writing select * from yourtablename as plan showing like this. If there are no. of columns in table then it will make slow.

3.Whether index stats are updated or not.

Its taking above 1 min to get result

Are you facing any issue?