<div>Hi</div>
<div> </div>
<div>I have an query related to an sql sever 200o using delphi 5. Not sure if this is the right palce to ask it. Still i belive may be soemone can help me in this</div>
<div> </div>
<div>I am creating a store procedure.</div>
<div> </div>
<div>In that i am fetching the information on the basis of join between two table.</div>
<div> </div>
<div>say table 1 and table2. Now thign is at my client place table 1 has 10 million records and table 2 has 15 million records.</div>
<div> </div>
<div>Now i have done a join between these two table depending on tabl1.x=table2.x and table1.y=table2.y. I have used the primary key in colum x of table 1 that emans it automaticaly created a clustered idex. Now problem is when i execute this query it takes more than hour to run this query. Any way i can reduce the time of query using any option.i can't use primary keys on table2 sicne i do have duplicate values.</div>
<div> </div>
<div>Regards</div>
<div>Vikas</div>
<div>Solution consultant</div>
<div>NCR coorporation<br clear="all"><br>-- <br> vikas </div>