On Mar 21, 2011, at 10:42 AM, preetika tyagi wrote:
> Query: INSERT INTO table1 SELECT * FROM table2. > Execution Time: A ms. > > Query: INSERT INTO table1 SELECT * FROM table2. > Execution Time: B ms
If session is same, then B < A if the data is cached due to execution of first statement. B > A, if the there is any change happened Or Any session has evicted the cached data.