1. A computer implemented method, executable in a database system, comprising: receiving at least one Structured Query Language (SQL) query that specifies requests involving blocks of data; identifying, by one or more processors, an optimized sequence relating to an order in which the blocks are to be retrieved into a storage for processing the requests, wherein identifying the sequence is based on information associated with the at least one SQL query, the information associated with the at least one SQL query including a type of database operation and predicates that are to be satisfied, wherein the predicates are specified by the at least one SQL query; and providing, by the one or more processors, an output for the at least one SQL query based on retrieving the blocks into the storage according to the identified sequence.