Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance Issue
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