[Info-ingres] Weird Optimizer error

This is a discussion on [Info-ingres] Weird Optimizer error within the Ingres Database forums in Other Databases category; Hi Dudes, Anyone got any idea what this means: E_OP0393 consistency check - the selectivity of a histogram was out of range 0.0...

Go Back   Database Forum > Other Databases > Ingres Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 12-22-2005, 11:02 AM
Default [Info-ingres] Weird Optimizer error

Hi Dudes,

Anyone got any idea what this means:
E_OP0393 consistency check
- the selectivity of a histogram was out of range 0.0 <= value <= 1.0

The box is II 2.6 patch 10993 on axp.osf. It is SQL-92 compliant.

I have had problems with stats on this thing before, and have reduced
the database in quesytion to optimizing keys only (-zk) with only default
stats buckets.

Anyone got an idea of how to identify which table(s) are causing the
problem?

Martin Bowes.
--
Random Duckman Quote #79:
Fluffy: Get the @#0& out of here Mr Duckman.
Uranus: You Deaf @#0&? Get the @#0&! outa here before we @#0&!
tear your
@#0& @#%& off and shove them up your @#0& @#0&!!

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 09:58 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.