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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 08:19:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.