I am new to Sql administration.Have one question.
We work for a govt organization and most of the end users are non-technical users.
Many a times I feel difficult to tell them in simple terms or a story the query performance is based on different factors.
They say, why the simple select query which returns 5 rows is taking 15-20 mins to retrieve data. I tell them in technical terms but they don't understand. blocking or waits etc... I also tell them that retrieving 5 rows from 10 rows table is different from 5 rows from a 2-3 table join which is scanning around 25 million rows.
My question is that, is there any analogies or metaphors to explain in a manner they understand what I am saying.