Effectiveness and Efficiency Issues for DBMS
Focus on the relational model
Any column in a relational database can be searched for values.
To improve efficiency indexes using storage structures such as BTrees and Hashing are used
But many useful functions are not indexable and require complete scans of the the database