Home » RDBMS Server » Performance Tuning » Help : Histograms Size
Help : Histograms Size [message #254855] Sun, 29 July 2007 11:07 Go to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi,
I am using Oracle 9i R2 on Linux

what could be best stategy for calculating or sizing histograms while gathering statitics on the table containg following table?

Count Value
27428982 1
327051 8
6375 13
68760 61
4365 70
22024913 75
17845 91
365812 102
15218 104
91 105
340328 106
4293 107
8 null

Query is using the column name as following at many places
WHERE nfinduetype IN ( 1, 8, 61, 91, 105 )

Thanks and Regards,
OraSaket
Re: Help : Histograms Size [message #254857 is a reply to message #254855] Sun, 29 July 2007 11:13 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

What are "count" and "value"?
Why the output is not sorted?

Try "size 254".

Regards
Michel
Previous Topic: Database hanged
Next Topic: how to increase a performance of a table in oracle 10g (merged)
Goto Forum:
  


Current Time: Fri Dec 09 11:33:13 CST 2016

Total time taken to generate the page: 0.10281 seconds