Plan Guides

This is the final spin off... so, good luck, mrs asian girl... yes you looked cute,
but your predecessor was a wicked witch.. here we go...
sql server 2005 has certain stored procedures named plan guides that are used to
cache path information so that if a certain query can be simulated to a degree, meaning that if the data is indexed correctly it is likely that regular queries will correlate to depth-wise traversal distance to the point where the plan "ends" (the node), then this query is optimized by changing the rate of its initial traversal (the transition function of the root node in the finite state, where the root node is a bounded set of paths around a circular entry point), and always being able to determine how best to insert new rate changes to consist with the objective of the query in transaction scope...
g