How to accelerate this query? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to accelerate this query?

Message

From

30/03/2001 15:14:22

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

To

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

How to accelerate this query?

Miscellaneous

Thread ID:

00490429

Message ID:

00490429

Views:

27

I would like to optimize this query.

SELECT MEMBER.*,MAX(LOGIN.CREATION) AS LOGINCREATION FROM LOGIN;
 INNER JOIN MEMBER ON LOGIN.NOMEMBER=MEMBER.NUMERO;
 WHERE MEMBER.NUMERO>=lnNumberStart AND MEMBER.NUMERO<=lnNumberEnd;
  AND MEMBER.MAILING=1;
 HAVING LOGINCREATION< DATE()-120;
 GROUP BY 1 INTO CURSOR TEMP

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Click here to load this message in the networking platform