[Solved] Temporary Table query taking time to execute in SQL Server

Question

hi i have a little questionsorry my english in my web applicationin a report page i should get a list from databaseBut result returns too lateSo ive changed my sql queryim creating a temp table and my main query left join with this tableat the end dropping the temp tableis this logicalmy query inculdes Creating temp table main select query dropping temp tablewhen this report page runs this sql query runs like thisis this a right way regards

Shashikant · Accepted Answer

Hi zamkinosYesif you have complex logic to get records from the table

manvendra45 · Answer

hello zamkinos your logic is good but sometimes  temp table  take more time to run query  so you can use a table variabletry this linkhttpstackoverflowcomquestions11858534whatcaniuseinsteadoftemptableinsqlfunction

[Solved] Temporary Table query taking time to execute in SQL Server

Company

Explore

Follow us

Contact Us