1. A computer-implemented method configured to provide caching of data retrieved from joined tables and an inheritance table hierarchy of a database in an enterprise, the computer-implemented method comprising: creating a queue of cursors based on a join statement associated with a database having a plurality of tables and/or table inheritance hierarchies, each one of the cursors representing a record in one of the tables or one table inheritance object according to one of the table inheritance hierarchies; evaluating one of the cursors of the queue to determine if the one of the cursors is one of a unique record in one of the tables or a unique table inheritance object according to the one of the table inheritance hierarchies; in response to evaluating that the one of the cursors of the queue is not one of the unique record or the unique table inheritance object, clustering where predicates and/or join conditions associated with the one of the cursors; and determining if the clustered where predicates and/or join conditions correspond to a unique index; in response to determining that the clustered where predicates and/or join conditions correspond to the unique index, marking the join statement as a unique join according to which one record or table object is fetchable from at least one of the tables; and in response to marking the join statement as the unique join, storing data of the one record or table object fetchable from the at least one of the tables in a data cache configured for retrieval from the data cache.