i need to figure out how to explain to business people that Oracle and SQL Server very complex, one might like to say intelligent creatures, that decide on their own how to run queries.
And while we can load, volume, and size test - none of it is the same as the real world.
And when a slowdown, or deadlocks, appear, it needs to be analyzed. Developers need to look at how SQL Server is deciding to run a query, and figure out if we can help it run it in some different way.
The experienced developer has a general idea how some query will be run, and that can be reflected in the initial design. But in the end, the collective heuristics of teams of developers of the database engine decide best how to run a query. And that changes over time, as the data changes.
i need to explain all this to business people; who want the system to be fully pinned down during design, and queries should now and forever run the same way - at the same speed, without deadlocks.
Where do i ask for advice on how to phrase this to non-database guys?
Why is this question on meta.SO? Because it's SQL Server related, but not a technical question.