Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prakashram
Starting Member
4 Posts |
 Posted - 2006-11-02 : 08:06:31
|
| Hi Friends,I have two tables, one table has 42 lacks records and other one has 8 lacks records.I have wrote inner join with two table but excutaion time to more, it is taking more than half an hour to execute.Please give the tips how can i improve this query.It's very urgent.ThanksPrakash |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-02 : 08:42:27
|
| Are the columns you are joining indexed (in both tables)?Kristen |
 |
|
|
prakashram
Starting Member
4 Posts |
Posted - 2006-11-02 : 09:41:46
|
quote:
Originally posted by Kristen
Are the columns you are joining indexed (in both tables)?Kristen
Yes both columns are indexed but still it's taking time |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-11-02 : 10:18:30
|
| You are posting this in the Analysis Services forum.Does it take time to run the query in Query Analyzer, or while loading up the cube/dimension?rockmoose |
|
|
|
prakashram
Starting Member
4 Posts |
Posted - 2006-11-02 : 10:32:33
|
| Yes it is taking time in query analyzer only.Please help me |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-02 : 12:08:25
|
| How many rows are you retrieving? If you are retrieving LOTS of result records then its probably just the retrieval (i.e. network) time.If that's the case how long does it take to execute if you change it to, say:SELECT TOP 10 ...?Kristen |
|
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2006-11-03 : 00:30:48
|
| Hi,can u post the query......... |
|
|
|
|
|
|
Improve the performance