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 -> Re: Histograms Used to Select Best Index, or Only Between Index and FTS?

Re: Histograms Used to Select Best Index, or Only Between Index and FTS?

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Thu, 18 Jul 2002 11:55:52 GMT
Message-ID: <ah6ao4$21k$1@news1.xs4all.nl> 





I should have been more specific.



For DSS kind-of-databases, histograms on all columns
for OLTP kind-oif databases: only if necessary. Agree with mr. Lewis.



Kind Regards,



Herman de Boer


sr consultant


IT Consultancy Group bv.



Jonathan Lewis wrote:



>

>In general I advise quite strongly against having

>histograms on all columns.

>

Received on Thu Jul 18 2002 - 06:55:52 CDT












Original text of this message













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