Jump to content

query optimization


Guest nishalu

Recommended Posts

Guest nishalu

hi, consider this situvation i am running query with inner join among 7 tables it is having laks of record and if i execute that query means it will take minimum 3 hrs means tell me clearly wat are all the ways to reduce the execution time of the queryreply me pls.........regards,nisha

Link to comment
Share on other sites

That's a huge question and in large part depends on the DBMS you're using. If you're using MS SQL Server then it comes with several analysis tools that help with things like suggesting indexes. You can look into a stored procedure, or else look for books about optimizing SQL. Like I said, it's a big topic.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...