Re: [Firebird-devel] SEC$USERS and indices

2017-09-20 Thread Alex Peshkoff via Firebird-devel
On 09/19/17 20:45, Magnus Johansson wrote: -Original Message- From: Alex Peshkoff via Firebird-devel [mailto:firebird- de...@lists.sourceforge.net] Sent: Tuesday, September 19, 2017 10:19 AM I'm curious about why there is no index on SEC$USERS.SEC$USER_NAME (*) You are right - because

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Magnus Johansson
> -Original Message- > From: Alex Peshkoff via Firebird-devel [mailto:firebird- > de...@lists.sourceforge.net] > Sent: Tuesday, September 19, 2017 10:19 AM > > > I'm curious about why there is no index on SEC$USERS.SEC$USER_NAME (*) > > You are right - because it's virtual table. Thanks

Re: [Firebird-devel] SEC$USERS and indices

2017-09-19 Thread Alex Peshkoff via Firebird-devel
On 09/18/17 23:39, Magnus Johansson wrote: Hello, I'm looking on FB 3.0 and doing some thinking comparing with FB 2.5. In 2.5 there is an index on RDB$USERS.RDB$USER_NAME and that field is defined as VARCHAR. In 3.0 there is no index on SEC$USERS.SEC$USER_NAME and it is defined as CHAR. Looki