Re: performance

Article View: borland.public.interbase.sql

Article #819

Back to borland.public.interbase.sql Previous Next

#819

From: Tiberiu Horvath
Date: Sat, 12 May 2007 06:31

25 lines
1593 bytes

Thank you very much !



Tiberiu


"Svein Erling Tysv�r" <svein.erling.tysvaer@kreftregisteret.no> wrote in 
message news:4644a2fb$1@newsgroups.borland.com...
> 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: <46455f3d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<464355cc@newsgroups.borland.com> <46439619$1@newsgroups.borland.com> <46449a74@newsgroups.borland.com> <4644a2fb$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,65a795d106dce3a2
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII
From: "Tiberiu Horvath" <exact@exactonly.ro>
Newsgroups: borland.public.interbase.sql
References: <464355cc@newsgroups.borland.com> <46439619$1@newsgroups.borland.com> <46449a74@newsgroups.borland.com> <4644a2fb$1@newsgroups.borland.com>
Subject: Re: performance 
Date: Sat, 12 May 2007 09:31:27 +0300
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 86.122.211.180
Message-ID: <46455f3d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178951485 86.122.211.180 (11 May 2007 23:31:25 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message