I am having one querry regarding the same line.
In my stored procedure i am fetching the data from one table containing upto 5 to 6 million rows I made use of index in my database but then also I cant optimise my execution time of that sp.
Please help me out of this problem.
Optimizing queries / stored procedure for retreiving millions of rows
Hot Topic
- How to pass Credential in url in SQL server Reporting Services?
- "WITH RETURNS NULL ON NULL INPUT" not working?
- SQL Reporting Services problems... urgent
- More tutorials of data mining in sql server 2000?
- Replicacion Merge SQL Server 2005 Express Edition
- Which Raid for SQL 2005
- Execute a SSIS master package through an ASP.NET web app
- Problem populating temp table from linked server.
- Dynamic building of reports in C# for ASP.NET
- I TRIED THE PACKAGE AND IT FAILS ALL THE TIME
SQL Server
- SSIS log viewing
- Does a synchronous transformation process all rows in a buffer before outputting to next transformation?
- No messages in the queues.
- Using connection managers inside custom log provider failing!
- ODBC linked table support in SQL SERVER 2005
- error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0
- Setting up Sql Mobile subscription
- How to remove unused columns and eliminate warnings
- Unistalling SQL SERVER 2005 Beta version
- Bug in SQL Server 2005 ? - DATEADD function
Optimizing queries / stored procedure for retreiving millions of rows
_Raj_
Try to give us the queryplan of your query, its the best and easiest thing to find bottlenecks. Use the query Analyzer for that or have a look on the SET SHOWPLAN ON and activate this priot to executing the query. It will put out a text (graphical plan) of your query where you can see if some lame things are done.
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---