Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To optimize Select - SQL, Group by
Message
From
29/11/2005 17:19:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
To optimize Select - SQL, Group by
Miscellaneous
Thread ID:
01073030
Message ID:
01073030
Views:
51
Hi, is it possible to make Rushmore optimization work here:?

Table1's PK expression is PKF1 + PKF2
Select PKF1, PKF2, Count(1) as nDup from Table1 group by PKF1, PKF2 ;
Having nDup > 1
Do I have to add any WHERE clause or any tip to see Optimization:Full?


Current result is "Optimization: None"

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform