Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

speed up query time

Status
Not open for further replies.

markororke

Programmer
Sep 19, 2001
2
IE
i am looking for a quicker way of performing this query:

Select count (distinct t1.child)) from WineHigh t1 join WinHigh t2 where t1.Seed = 14 and t1.depth =3 and t2.depth<3 and t1.child = t2.child and t1.Seed = t2.Seed;

this is used primarily to return the no. of distinct child of t1 that where previously there in previous levels.....

in other words the query is comparing results at level 3 to previous levels to return the number of times they are the same.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top