Re: Indexing NULL in the Oracle Database, is this the best practice?
From: Michael D O'Shea/Woodward Informatics Ltd <woodwardinformatics_at_strychnine.co.uk>
Date: Wed, 4 Jan 2017 12:31:18 +0000
Message-Id: <D309B4E5-D7A9-41B7-9427-62E8682E3494_at_strychnine.co.uk>
Date: Wed, 4 Jan 2017 12:31:18 +0000
Message-Id: <D309B4E5-D7A9-41B7-9427-62E8682E3494_at_strychnine.co.uk>
Thank you for your informative comments Mladen.
> In that case your "don't use undocumented hints in production" principle doesn't hold water.
As I spread myself out over a wide number of development technologies, I take on the advice of those that specialise and are respected in the field. I find his book very well written and authoritative so at the time took a mental note regarding the OPT_ESTIMATE hint.
Regards
Mike
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 04 2017 - 13:31:18 CET