[DUG] sql query issue

[Vikas...]

Hi

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

I am creating a store procedure.

In that i am fetching the information on the basis of join between two
table.

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.

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.

Regards
Vikas
Solution consultant
NCR coorporation

-- 
  vikas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080508/11ed550c/attachment-0002.html