Re: Distinct values

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 4 Aug 2010 18:24:14 +0200
Message-ID: <4c599432$0$434$426a74cc_at_news.free.fr>

"Mladen Gogala" <no_at_email.here.invalid> a �crit dans le message de news: pan.2010.08.04.15.44.06_at_email.here.invalid...

|I have recently had a conversation with an Oracle support engineer who
| told me that, when analyzing VARCHAR2 columns, Oracle only counts the
| first 32 characters. I checked the statement and it is true:
|

<...>

|
| -- 
| http://mgogala.byethost5.com

This has always been true in any version since CBO was introduced. I even wonder if it was not less in the previous versions but I can't remember.

Regards
Michel Received on Wed Aug 04 2010 - 11:24:14 CDT

This message: [ Message body ]
Next message: Steve Howard: "Re: DBMS_STATS runs for hours and creates no stats"
Previous message: Mladen Gogala: "Re: Distinct values"
In reply to: Mladen Gogala: "Distinct values"
Next in thread: Randolf Geist: "Re: Distinct values"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message