Re: Using Index in VDB7

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

Article #1290

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

#1290

From: Lu-Khon Mai
Date: Mon, 16 Feb 1998 00:00

20 lines
1225 bytes

SQL knows nothing about MDXs but will use indexes if available?  Is this
true if your index's key is based on an expression?  Will SQL know to
use this index?

Bowen Moursund wrote:
> 
> >On browsing a tables directly from popup menu in Navigator, it's not
> >possible to set a TAG Order.
> 
> You cannot directly select an index tag, no. However, with the table open,
> you can select Table|Sort from the menu. Indexes will be used if available.
> 
> >The same situation is in Query designer. Is correct?
> 
> Yes. SQL knows nothing about MDXs.
> __
> Bowen Moursund (TeamB)
> bowen.NOSPAM@nerds.com
> http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <34E8C786.8565C896@dvi-nw.com>

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

References: <34BF6233.549E@mbox.vol.it> <69ob6n$f3t4@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,4e1ec54d21865ff8
X-Google-Attributes: gidff5a1,public
From: Lu-Khon Mai <lu-khon@dvi-nw.com>
Subject: Re: Using Index in VDB7
Date: 1998/02/16
Message-ID: <34E8C786.8565C896@dvi-nw.com>
X-Deja-AN: 325687204
Content-Transfer-Encoding: 7bit
References: <34BF6233.549E@mbox.vol.it> <69ob6n$f3t4@forums.borland.com>
To: Bowen Moursund <teamb@opto-pps.com>
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message