Re: Performance Issue

Hi There,

There are a number of reasons why you could have the difference.

My recommendation would be to trace each query and see what the execution plan and statistics have to say. I would only be guessing, this would tell you the truth.

Cheers

Richard
"TC3 Racer" <gordonchapman_at_hotmail.com> wrote in message news:gb1d9.4100$J47.310606_at_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 - 08:11:42 CDT