3 ms·
Actually, it can have a significant impact but it's a corner case. It's a moot point though - as an example, SQL Server stores plans in a memory cache. [1] 1.
by chris_wot 14y ago
Actually, it can have a significant impact but it's a corner case. It's a moot point though - as an example, SQL Server stores plans in a memory cache. [1]
1. http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory http://www.sqlteam.com/article/what-query-plans-are-in-sql-s...
edit: incidentally, one of the corner cases I can think of is joining 10 tables, which gives you 10! combinations for the query processor to work through. This is irrelevant in MemSQL, because you can only join to another two tables, and you cannot do right outer for full outer joins.
- chris_wot 14y agoInterested in knowing why this has been voted down! A response would have been more useful. Would love to know what is inaccurate about my comment.