[DUG] sql query issue

[Neven MacEwan]

Vikas

Can you post the text of the query?

Basic Pointers

1/ Add indexes for ther foreign keys (these can allow duplicates)
2/ Restrict the result set (I assume you dont want the query to return 
10 million rows)
3/ use ansi join syntax

N


> 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
> ------------------------------------------------------------------------
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe