Ok, Thanks Martijn and Dimitry
Eric
Le lun. 6 janv. 2020 à 16:57, 'Martijn Tonies (Upscene Productions)'
m.ton...@upscene.com [firebird-support]
a écrit :
>
>
> Eric,
>
> Yes, the optimizer can use an index with a WHERE on a VIEW, but only when
> the view is local, not when using EXECUTE STAT
Eric,
Yes, the optimizer can use an index with a WHERE on a VIEW, but only when the
view is local, not when using EXECUTE STATEMENT on an external database.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
From: Eric Guéguiniat eric.gueguin...@gmail.com [firebird-suppo
06.01.2020 16:52, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]
wrote:
> That why I need to select directly an external table in a view, instead a
> stored procedure
You cannot. Firebird doesn't support that.
--
WBR, SD.
On 05/01/2020 15:55, John M buff...@gmail.com [firebird-support] wrote:
>> > My DB is very small at < 200MB. Is it better to upgrade to FB 2.5.9
>> > before the win upgrade? If so, what is the best way to do this upgrade?
>> >
>> > I have spent several hours already googling answers, but none I
Index are used with a view when the source is a table and not if it's a
stored proc
This view CUST_VIEW use index : SELECT * FROM CUSTOMER => SELECT * FROM
CUST_VIEW WHERE IDCUSTOMER = 1 , INDEX on IDCUSTOMER is used
The view CUST_SPVIEW don't use index : select * FROM STORED_PROC_CUSTOMER
=> SELE
06.01.2020 14:48, Eric Guéguiniat eric.gueguin...@gmail.com [firebird-support]
wrote:
> I can't use Stored procedure to do this, because index are not used with it
Index cannot be used with ES either, so there is no difference and no need
in a view.
--
WBR, SD.
Mark - thank you very much!
I do want the backup file on the server so all is good there.
I have found that the spaces do cause an issue. Where I’m at right now is the
following:
gbak -b -user sysdba -password masterkey -service win2012server:service_mgr
c:/~wrk/lumber.fdb/common/lumbe
Hello,
Is it possible to create a view on external table ?
I need to replace a table of the DB by an external table. Like this I don't
need to modify my stored procedures
I can't use Stored procedure to do this, because index are not used with it
I tried to do this, but it's not correct :
CREATE