Query can not be optimized? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Query can not be optimized?

Message

From

02/10/2006 12:16:16

Sergey Berezniker
New York, United States

To

02/10/2006 12:11:37

Kevin Lawrence
Cornwall Council
United Kingdom

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Query can not be optimized?

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01158559

Message ID:

01158590

Views:

26

>Yeah I spotted that ;-)
>
>Thanks for both of your responses, however I'm getting the same results :-(

Can you post SYS(3054,11) output? How many records are in each table? Is query optimizable if you run it w/o WHERE caluse ? Can you create an index on cl_dob field and run query again?

--sb--

Click here to load this message in the networking platform