I have a SharePoint 2010 publishing site collection with a Term Store that I want to use for navigation. I understand the process of get the collection of published pages and examining the managed metadata column for a specific term or terms, but is it possible to find all items tagged with a specific term without iterating through every single page? Kind of like flipping the one to many relationship of items, pages, etc. to terms around backwards so for each term there could be one or more items using it.
If this doesn't make sense I'll clarify.