Limit rows evaluated

In a DataWarehouse environment, some columns act as a flag for current or historic rows.  The ability to select one column with a criteria applied would GREATLY enhance usability for us.  Our tables have over 100 million rows but only 10 million or less are active...and they are the only ones we care about.  Without that filter great as this tool is, it's not effective or even useful for most of our tables.