Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performance Issue

Performance Issue

From: TC3 Racer <gordonchapman_at_hotmail.com>
Date: Tue, 3 Sep 2002 12:42:06 +0100
Message-ID: <gb1d9.4100$J47.310606@stones>

I have a table that a select Count(*) .... takes 5-10 secs A table that is a copy of this with only 4 columns of the above comes back instantly.

Full Table

 DOUBLE_METAPHONE                   NOT NULL VARCHAR2(50)
 ORIGINAL_STRING                            NOT NULL VARCHAR2(50)
 PHONETIC_STRING                          VARCHAR2(100)
 POI_TYPE                                            NOT NULL VARCHAR2(50)
 ROAD_NAME                                     VARCHAR2(100)
 TOWN_NAME                                     VARCHAR2(50)
 COUNTY_NAME                                 VARCHAR2(50)
 SRS_NAME                                         NOT NULL VARCHAR2(50)
 X_COORDINATE                                NOT NULL NUMBER
 Y_COORDINATE                                NOT NULL NUMBER
 SEGMENT_ID                                     NOT NULL NUMBER(38)
 ROAD_MATCH                                   NOT NULL NUMBER(1)
 PRIORITY_LEVEL                              NOT NULL NUMBER(2)

 Copy of

  NAME                                                NOT NULL VARCHAR2(50)
  TYPE                                                 NOT NULL VARCHAR2(50)
 X                                                        NOT NULL NUMBER
 Y                                                        NOT NULL NUMBER

 Any suggestions as to what the possible problem could be or what i should do to investigate further

 Many Thanks

 GC Received on Tue Sep 03 2002 - 06:42:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US