QUESTION POSED ON: 09 November 2008 I had control of what data gets entered into my table, I could potentially avoid the need for LEFT OUTER JOIN. For example, I could create dummy matching records in the join table with null values, thus negating the need for a LEFT OUTER JOIN. Will I get better performance if I do so and is this a good design approach?
To continue reading for free, register below or login
Requires Membership to View
To read more you must become a member of SearchOracle.com
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.