Sample Header Ad - 728x90

To inquire about the query complexity of the following query in SQL

-1 votes
2 answers
558 views
I would like to inquire about the complexity of the following example query in SQL:
SELECT id
from DB
where Country = "India"
    AND Size = "Large"
That is, taking the AND of rows matching the filters for any two columns out of **m>>2** columns. I want to return the first column which contain the ids. Can it be done in time sublinear in the number of rows? Thank you.
Asked by Neel Karia (1 rep)
Feb 14, 2022, 09:31 AM
Last activity: Feb 15, 2022, 03:04 AM