SQL & PL/SQL

Hi all,

I ran similar query say

    
     
select a.col1,
       a.col2,
       a.col3,
       b.col4,
       b.col5,
       b.col6
       from table1 a,
            table2 b
       where a.col5 = b.col5
             a.col4 = b.col4;
        
     
    

When i ran this query in sqlplus

     sqlplus
       It fetched 26k all the rows in sqlplus
             With Elapsed time 15:20 (mi:ss)

       

But when i ran the same query in TOAD(Third party Editor)

                
            TOAD

              I could see in query analyzer saying execution time is 3:26 (mi:ss)  and rows processed 26k
         
           {code}


          When i ran the same query with count(*) with same filter condidtions i,e in *SQLPLUS*

           {code}
                  
                  SQLPLUS
                  select count(*)    
                                  from table1 a,
                                          table2 b
                               where a.col5 = b.col5
                                         a.col4 = b.col4;
                   
                        I see the elapsed time 1:20 (MI:SS)  for row count26k
             
           {code}

       
                 
So i m little confused ...can you gurus justify which one is correct and more valid ??? Thank you so much!!

Edited by: user642297 on Jun 30, 2010 4:37 PM