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 => SELECT * FROM CUST_SPVIEW WHERE IDCUSTOMER = 1 , No index
That why I need to select directly an external table in a view, instead a stored procedure Thanks Eric Le lun. 6 janv. 2020 à 16:35, Dimitry Sibiryakov [email protected] [firebird-support] <[email protected]> a écrit : > > > 06.01.2020 14:48, Eric Guéguiniat [email protected] > [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. > >
