On 24/01/16 08:04, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support] wrote:
> I needed some time to understand (at least try to understand) your post.
> Please, note that my SQL knowledge is very limited. I really don’t know
> internals of database any system. Though, I need to
Den 24.01.2016 09:04, skrev Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support]:
> Hello,
>
> I needed some time to understand (at least try to understand) your post.
> Please, note that my SQL knowledge is very limited. I really don’t know
> internals of database any system. Though,
turday, January 23, 2016 1:42 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Hi, sorry for a bit late reply. I had to rewrite your query to actually
understand it, I'm not used to SELECT FROM (SELECT FROM (SELECT...
This
hoogroups.com>
Data: 21.01.2016 00:18 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Sorry, for my formatting. Here is a better one. I have uploaded image.
Link: http://s16.posti
: Thursday, January 21, 2016 5:14 PM
To: firebird-support@yahoogroups.com
Subject: ODP: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
hi,
this is what i supposed. Hash match. And as Arno Brinkman say you have not
defined indexes on filtered columns
regards,
Karol Bieniaszewski
, January 21, 2016 5:02 PM
To: firebird-support@yahoogroups.com
Subject: RE: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Hello,
I will created indexes necessary. However, I think I cannot do anything about
Hash match. Is it making Firebird slower Hash match? I don't know
ee very slow response
> in Firebird.
>
> regards,
> Karol Bieniaszewski
>
> From: mailto:firebird-support@yahoogroups.com
> Sent: Thursday, January 21, 2016 5:02 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimi
-support@yahoogroups.com
Sent: Wednesday, January 20, 2016 4:57 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Hi,
I have below tables.
CREATE TABLE BAZLISTE
(
ADRESKODU varchar(30) NOT NULL,
ISLEMTURU varchar(2) NOT NULL
@yahoogroups.com
> Sent: Wednesday, January 20, 2016 4:57 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
>
>
> Hi,
>
> I have below tables.
>
>
> CREATE TABLE BAZLISTE
>
> (
>
>
Hi,
I have below tables.
CREATE TABLE BAZLISTE
(
ADRESKODU varchar(30) NOT NULL,
ISLEMTURU varchar(2) NOT NULL,
BELGENO varchar(30) NOT NULL,
BARKOD varchar(30) NOT NULL,
MIKTAR bigint,
OLCUBIRIMI varchar(10),
PRIMARY KEY (BELGENO,BARKOD,ADRESKODU,ISLEMTURU)
: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
I do not spend much time on this – maybe my conclusions are not good but also
you have not any index usage for this subquery
SELECT
AdresKodu,
IslemTuru,
BelgeNo
Brinkman
From: mailto:firebird-support@yahoogroups.com
Sent: Wednesday, January 20, 2016 4:57 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Hi,
I have below tables.
CREATE TABLE BAZLISTE
(
ADRESKODU varchar(30
: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
I’m all new to these things. Below is what I could find on MSSQL. I hope that
is what you are looking for.
From: mailto:firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, January 21, 2016
From: liviusliv...@poczta.onet.pl
Sent: Wednesday, January 20, 2016 11:17 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Hi,
i see that you have only partial key usage on 1/4
only BelgeNo is used because you do not use “BARKOD
14 matches
Mail list logo