Use case stuck due to Partitioning

Hi All,

Please find my use case below and suggest the appropriate solution:

We have done declarative partitioning over our table A based on some key
and further range sub partitioned each partition on the basis of
createddate range of 90 days.

In the search query to display last 90 day data , I give both column B and
createddate which may pick any of the required partitions.

But how can I display last 90 days data in which a record which is modified
last is also shown at the top but its created date might not lie in the
last 90 days range..

Basically, I need to partition my huge table based on some key and also on
date to split the data into smaller dataset for faster query . The UI needs
to display the latest modified records first but the created date also
needs to be given in the query to pick the right partition...

Can we do partition differently to achieve this?
Should i find the max modified date and give it in the range of the
created date.

Thanks & Regards