On 19 Jul 2015 10:29:04 -0700, map...@gmail.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Hello all, I have some questions about the param -T for nbackup and…
https://plus.google.com/b/111558763769231855886/+DobrinPetkov/posts/YGswA4f6KjF
I have not heard back from anyone on this and the office is asking me to
provide an answer on this. So please, can someone that has experience with
this or know for sure, let me know?
Thanks,
Mike
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent:
if not indicate id_master the query must scroll all id_master (then the
entire archive) so you better define the index: CREATE UNIQUE INDEX ON
UNQ_DETAILS_DATA DETAILS_DATA (ID_PARAM, ID_MASTER) to limit your search to
only id_param = 60 with query where id_param = 60. greetings
So, if I change the order of fields in the index I can speed things up. Could
someone explain me why it works like it works? What are the internals behind
this?
simple
(field1,field2) (field2,field1)
1111
2x 1 4
3x 1 8
41 x 2
5x x 3
6x x 5
7x x 6
81
it makes sense to use parts of keys provided are used those with the highest
level because significantly reduce the readings otherwise should build an
index for that purpose. greetings
---Messaggio originale---
Da: brucedickin...@wp.pl [firebird-support]
Data: 20/07/2015
On 20 Jul 2015 05:20:31 -0700, brucedickin...@wp.pl [firebird-support]
firebird-support@yahoogroups.com wrote:
So, if I change the order of fields in the index I can speed things up.
Could someone explain me why it works like it works? What are the
internals
behind this?
Simplified the index
and 'exactly this way because you do not know the value of ID_MASTER then
want all ID_MASTER without have index based on ID_PARAM. hello
---Messaggio originale---
Da: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
Data: 20/07/2015 15.57.13
A: firebird-support@yahoogroups.com