* firebird-support@yahoogroups.com
> *Subject:* Re: [firebird-support] Create view on external table
>
>
>
> 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
&
-support]
Sent: Monday, January 6, 2020 4:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Create view on external table
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 =>
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.
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.
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