September 5, 2017 at 3:29 am
Hi,
what is the best way to retrieve the data at a faster rate. I am having the data of around 6,00,000 and is taking around 2 mins to execute the query. I tried with indexing the table [with clustered index on the column from which I am filtering the data].
the query is inside the stored proc and the stored proc execution is taking time [as said above - 2 mins]. I have stored all the data into a single table, earlier it was 4-5 tables were joined.
Please help me to come out of this.
Thanks
Arun
September 5, 2017 at 3:33 am
Welcome to SSC.
Have a look at Jeff's Article on how to post performance problems. There's little we can do to help you with next to no information.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 5, 2017 at 5:56 am
Thom has it nailed. Without information, we can't help.
One little point, depending on the type of query (and since we can't see it, who knows), putting everything into a single table is not going to make things faster. SQL Server is pretty darned good at joining data between tables. It's designed to do that after all. It's down to your query and your database design more than anything else.
"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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply