Re: Why does ittake long time?

Just do explain plan for this and look... It seems it isn't so simple ;)

Gints Plivna
IT Sistēmas, Merķeļa 13, LV1050 Rīga
http://www.itsystems.lv/gints/

                                                                                       
                            
                    Roland.Skoldbl                                                     
                            
                    om_at_ica.se            To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    Sent by:             cc:                                           
                            
                    root_at_fatcity.c       Subject:     Why does ittake long time?       
                            
                    om                                                                 
                            
                                                                                       
                            
                                                                                       
                            
                    2001.10.25                                                         
                            
                    13:25                                                              
                            
                    Please respond                                                     
                            
                    to ORACLE-L                                                        
                            
                                                                                       
                            
                                                                                       
                            

Hallo,

Why does this query take so longtime to run...At least 20 minutes it is just a simple count...

(Embedded image moved to file: pic24685.pcx)

Thanks in advance

Roland Sköldblom

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: G.Plivna_at_itsystems.lv

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).