Index only select

11 views
Skip to first unread message

Ertan Küçükoglu

unread,
Jul 11, 2022, 4:20:16 PMJul 11
to firebird...@googlegroups.com
Hello,

I am using 2.5.9 and 4.0.1 versions of FirebirdSQL. I wonder if there is such a thing as index only search in FirebirdSQL. I know some other database systems like PostgreSQL have it.

If yes, how can I identify it from the query plan?

Thanks & Regards,
Ertan

Dimitry Sibiryakov

unread,
Jul 11, 2022, 5:39:49 PMJul 11
to firebird...@googlegroups.com
Ertan Küçükoglu wrote 11.07.2022 22:20:
> I am using 2.5.9 and 4.0.1 versions of FirebirdSQL. I wonder if there is such a
> thing as index only search in FirebirdSQL. I know some other database systems
> like PostgreSQL have it.

No, Firebird cannot do index-only data retrieval.

--
WBR, SD.
Reply all
Reply to author
Forward
0 new messages