Forcing vdb7 to use indices in sql-queries?

Article View: borland.public.vdbase.data.sql

Article #5

Back to borland.public.vdbase.data.sql Previous Next

From: Dirk Steinkamp
Date: Wed, 25 Feb 1998 00:00

20 lines
1543 bytes

Hi,

When using vdb5.5 one could create queries that linked tables using
existing indices.

Now, in vdb7 with the new sql-query-generator it seems not possible to
force vdb to use any index (when using local sql). We have a some
databases with order-information, article-information and a large
customer-addresses linked by article-id resp. customer-id. When creating
a query with these databases it takes very much longer (very much too
long!) than in vdb5.5 (or even dBase IV for DOS!). This is also true
when the resulting view is quite small (only the customer database is a
very large one)!
It seems vdb doesn't optimize anything here and does not use an existing
index, does it? Can I force vdb to use this index? Any other
suggestions?

Thanks,
Dirk

Technical Details

Message-ID: <34F4904B.7200@ping.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 105c7d,d5b52dc183f66711,start
X-Google-Attributes: gid105c7d,public
X-Google-Thread: ff5a1,d5b52dc183f66711,start
X-Google-Attributes: gidff5a1,public
X-Google-Thread: 108edc,d5b52dc183f66711,start
X-Google-Attributes: gid108edc,public
From: Dirk Steinkamp <D.Steinkamp@ping.de>
Subject: Forcing vdb7 to use indices in sql-queries?
Date: 1998/02/25
Message-ID: <34F4904B.7200@ping.de>
X-Deja-AN: 328631864
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Reply-To: D.Steinkamp@ping.de
Newsgroups: borland.public.vdbase.data.sql,borland.public.vdbase.data.bde,borland.public.vdbase.programming