Hi ,
i have this very complex query joining mulitple tables.
When i do select * from <Query> , i am getting the results back in 2.5 seconds. Very good.
But when i select 10 column names from <query> it runs in 2.5 seconds for the first time but from 2nd time onwards it takes around 1 minute.
The explain plan looks similar for both the queries.
can somebody help me to guide where should i be looking at the issue ?
NOTE:- If i reduce no. of columns from 10 to 6 , the query results in less than a minute .. say around 50 seconds. The less the no. of columns in select clause, the time is getting reduced.
I selected only 1 column and it still resulted out in 30 seconds.
Thanks,