Performance Issue

[Quoted] [Quoted] I have a table that a select Count(*) .... takes 5-10 secs [Quoted] 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)
[Quoted] [Quoted]  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 - 13:42:06 CEST