We have no idea what you select query is, or what it's trying to do - so there is nothing we can directly do to speed it up, or even suggest improvements.
So all we can do is direct you to the
Performance Monitoring and Tuning Tools - SQL Server | Microsoft Docs[
^] and suggest that you start reading!
Quote:
i have a simple SQL statement
SELECT Data FROM [Table_1] where EmpID=661 and SrNo=2
the above Query takes about 2 to 3 seconds to execute because it contains blob data
SELECT FileName,Type FROM [Table_1] where EmpID=661 and SrNo=2
the above Query takes about 0 seconds to execute
is there any way to improve the performance.
No. That's a very simple query - the time is being taken in the sheer amount of data being transferred, which takes a finite time depending on the bandwidth of the connection between the server and the client.
At a guess, you are storing very large data in your DB, which is always a bad idea. Instead, store the data on a file server, and store a link to the file in your DB.
Check your blob size:
DATALENGTH (Transact-SQL) - SQL Server | Microsoft Docs[
^] and I'm pretty sure it'll be quite large...