2010/3/28 Tadipathri Raghu <traghu....@gmail.com> > Hi Guz, > > Thank you for the prompt reply. > > >> No, the optimizer is not retrieving anything, it just assumes that there >> are 2400 rows because that is the number of rows that exists in the >> statictics for this table. The optimizer just tries to find the best plan >> and to optimize the query plan for execution taking into consideration all >> information that can be found for this table (it also looks in the >> statistics information about rows from this table). > > > So, whats it assuming here as rows(2400). Could you explain this. > > > It is assuming that there are 2400 rows in this table. Probably you've deleted some rows from the table leaving just one.
regards Szymon Guz
