Now a days, I got used to hear the same question again and again from the various interviewers. The first sentence is like: "Are you in Performance Tunning" or "Do you tune your oracle code" or "what steps you will follow to tune your code". And very often they used to ask me like: "One query was executing normal till 2 days back, but today it is taking a bit longer time, so what steps you will follow to solve the issue". I tried to answer this in various ways like: 1) source table structure got modified 2) numbers of rows in the source table might got increase 3) need to collect stats of source tables (analyze tables) and many others. But I don't know the exact answers for this. Can anyone please explain or suggest to answer it very elegantly........ @