Multiple join conditions on indexed fields VERY slow...

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Multiple join conditions on indexed fields VERY slow...

Message

From

06/05/2004 06:41:20

Fabio Lunardon
Lunacom
Marostica, Italy

05/05/2004 16:43:20

Darren Young
Fashion Marketing
Carteret, New Jersey, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Multiple join conditions on indexed fields VERY slow...

Miscellaneous

Thread ID:

00901362

Message ID:

00901494

Views:

...
any thoughts? are multiple condition joins just slow??

When VFP have a multiple condition joins, if it can,
it build a temp index and use this on the join loop.

You can post the SYS(3054,11) output ?

Map

View

Click here to load this message in the networking platform