Re: performance

Article View: borland.public.interbase.sql

Article #818

Back to borland.public.interbase.sql Previous Next

#818

From: Svein Erling Tysvær
Date: Fri, 11 May 2007 17:08

16 lines
1612 bytes

Tiberiu Horvath wrote:
> One more thing.
> 
> To avoid using the index, if the field is of Char() type, can I use
> 
> where
>    produse.name_of_product='Something'+''?

Yes Tiberiu... well, close at least - '+' isn't used for concatenation 
and you have to concatenate it to the field where you don't want the 
index to be used, not the other side of the expression (and certainly 
not with a constant):

where produse.name_of_product||'' = 'Something'

Set

Technical Details

Message-ID: <4644a2fb$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <464355cc@newsgroups.borland.com> <46439619$1@newsgroups.borland.com> <46449a74@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,65a795d106dce3a2
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Fri, 11 May 2007 19:08:12 +0200
From: Svein Erling Tysvær
 <svein.erling.tysvaer@kreftregisteret.no>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: performance 
References: <464355cc@newsgroups.borland.com> <46439619$1@newsgroups.borland.com> <46449a74@newsgroups.borland.com>
In-Reply-To: <46449a74@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 000739-3, 11.05.2007), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 80.203.64.24
Message-ID: <4644a2fb$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178903291 80.203.64.24 (11 May 2007 10:08:11 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message