I am trying to understand how does databases like Oracle handles sql query that has many where (and) clause specially when databases has 1000's of entries.
Does it break it many smaller queris and then merge or something else?
example) consder a DB that has 1000 records
give me all records if department=account, AND age>=50 and job_level=4.
simple ugly way is to compare sequential all 1000 records but that would be bad if we have million entries. Does the Database maintains some additional structures also for faster processing