Nevermind, I see why it's using an index. There is a foreign key from group_users to the users table based on (col2, col5). So when I join by col2, it uses the index. If I use col5, it probably won't use the index since col2 is missing.
- [firebird-support] Is this query using an index? firebirdsql
- Re: [firebird-support] Is this query using an in... Svein Erling Tysvær
- [firebird-support] Re: Is this query using a... firebirdsql
