OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed
« How to find the longest common substring pattern in different group of strings in SQL

How to find the earliest day that is at least one year after the prior calculated date in SQL »

Create a Histogram on a Specified Column

August 21st, 2007 By srinivas.vangari

Hi,

We have a requirement to create a histogram on a specified column (release_flag) using FND_STATS.LOAD_HISTOGRAM_COLS(). This column has only two values ‘N’ and ‘Y’. We need to create the histogram on this column for the value of Flag status ‘N’.

Please share your views, syntax and advice to create the histogram.

This would be a great help to me.

Regards,

Srinivas vangari.

Filed under Tuning. Follow any responses to this entry through this RSS 2.0 feed.  

One Response to “Create a Histogram on a Specified Column”

  1. Eddie Awad Says:
    August 21st, 2007 at 10:08 pm

    You may find the following article helpful: Judicious Use of Histograms in SQL Tuning (PDF).

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question
« How to find the longest common substring pattern in different group of strings in SQL

How to find the earliest day that is at least one year after the prior calculated date in SQL »