Hi Mathias
I did not have to recreate my database with FB 3.0.5. The before/after example
was around upgrading the server only, with no database changes.
(my database was created in FB 3.0.4 / ODS 12 with schema/data migrated across
from an ancient InterBase 7.5.1 db, and is still on sql dialec
On 02-03-2020 18:24, 'm...@spectrumpacsold.com' m...@spectrumpacs.com
[firebird-support] wrote:
>
>
> Hello, why do we keep getting so many copies of this email? Thanks.
Looking at the headers of the emails, Yahoo Groups is repeatedly sending
the emails. According to the headers, it was sen
This advice should be oppositeYou should not have order by in the view.Only
exception is when you always do only simple select * from myviewRegards,Karol
Bieniaszewski
null
The optimizer uses the selectivity of an index to decide to use or not to use
an index.
Can You post the DDL of the table and the view?
Did You order inside the view or outside the view?
Example:
MyView = select * from Table order by Colum desc;
Select * from MyView
Or
MyView = select * from
03.03.2020 13:23, Matthias Winkler spmm...@gmail.com [firebird-support] wrote:
> The question is when and how decides the generator
> of the "plan" that it connot use the indexes
http://www.ibase.ru/dataaccesspaths/
--
WBR, SD.
--
Hello,
I already re-calculated the indexes. But as far as I understood is that as
soon
as the natural keyword is present the indexes are not used at all.
The question is when and how decides the generator
of the "plan" that it connot use the indexes
Matthias
On Tue, Mar 3, 2020 at 1:1
Can You check the selectivity of the index? Perhaps You could recalculate that
selectivity: http://www.firebirdfaq.org/faq167/
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 3. März 2020 12:41
An: firebird-support@yahoogroups.com
Betreff: Re: [
Hello,
it seems the problem is related to the VIEW. This is what I also figured
out so far. Now I read:
"If you see a *NATURAL *plan going against a big table, you've found the
problem. If you have where clause or JOIN to that table, make sure you have
index defined on related fields. If you do h
03.03.2020 07:42, liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
wrote:
> What is the reason for such limit?
This is select()'s limit on POSIX platforms. The code is unified.
--
WBR, SD.
++
Hi MarkWhat is the reason for such limit?Microsoft say only limit by available
RAMhttps://docs.microsoft.com/en-us/windows/win32/winsock/maximum-number-of-sockets-supported-2Regards,Karol
Bieniaszewski
null
10 matches
Mail list logo