On Thu, Jan 7, 2010 at 11:11 PM, akp geek <akpgeek@gmail.com> wrote:
> I have query in production and test. The tables in both the environment has
> the same structure ,indexes and constraints. But the in the test and the
> prod the explain plan is totally different. In test environment the query is
> taking long time and noticed that indexes are not being utilized ? I am not
> able to figure it Can you please share your thoughts?
Is the same amount of data in both? Are the other configs of the
server the same?