🚀 go-pugleaf

Dirk Steinkamp wrote:
> 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?

Try just using a query object, and setting the SQL property to something
like: "select * from customer". 

Then, set the rowset (of the query)'s indexName property to whatever
index you need.

Suggest reading Chapter 6 of the Developer's Guide (which ships with
VdBASE 7).

-- 
Ken[1]@Borland
<Please follow-up to newsgroup; do not reply to email>