🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Forcing vdb7 to use indices in sql-queries?

#3
From: Peter Rorlick
Date: Fri, 27 Feb 1998 00:00
21 lines
1384 bytes
Steve Koterski wrote:

> More information, please:
>
> What type of local table? dBASE or Paradox? What level table?

dBase level 7.

> What type of index was used? Primary or secondary? Single- or
> multi-column?
> dBASE expression index?

Index on Customer_ID tag CustNo
In other words, to a tag in an MDX.
BTW what are primary/secondary indexes? I've developed in xbase for 16
years and I've never encountered that phrase.

-------------------------
Peter Rorlick
Montreal Business Software
Technical Details
Message-ID: <34F740D9.9990DA28@InjuryTracker.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <34F4904B.7200@ping.de> <34F49515.16C0@borland.com> <34F62866.E950F244@InjuryTracker.com> <34f6f7c6.3971607@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 105c7d,d5b52dc183f66711
X-Google-Attributes: gid105c7d,public
X-Google-Thread: ff5a1,d5b52dc183f66711
X-Google-Attributes: gidff5a1,public
X-Google-Thread: 108edc,d5b52dc183f66711
X-Google-Attributes: gid108edc,public
From: Peter Rorlick <peter@InjuryTracker.com>
Subject: Re: Forcing vdb7 to use indices in sql-queries?
Date: 1998/02/27
Message-ID: <34F740D9.9990DA28@InjuryTracker.com>
X-Deja-AN: 329258109
Content-Transfer-Encoding: 7bit
References: <34F4904B.7200@ping.de> <34F49515.16C0@borland.com> <34F62866.E950F244@InjuryTracker.com> <34f6f7c6.3971607@forums.borland.com>
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Organization: MBS
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql,borland.public.vdbase.data.bde,borland.public.vdbase.programming