Autolocate
Benjamin Thompson shared a blog post on the AUTOLOCATE feature, saying it is more far-reaching than the manual suggests. Paul Watson and SangGyu Jeong thanked him. Oyvind Gjerstad asked whether index placement follows the same logic (16KB dbspaces); Benjamin had not yet looked into it but thought 16 kB for indexes would be sensible.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I have written a deep-dive blog post, which you may be interested in reading, on the relatively new AUTOLOCATE feature. It is a lot more far-reaching than it seems from just reading the manual. (With thanks to HCL Support for initially pointing out its use.) https://informixdba.wordpress.com/2020/09/18/autolocate/ ------------------------------ Benjamin Thompson ------------------------------ #Informix
Very useful - productive use of Plague Lockdown J
Thank you for sharing the great article. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Very interesting! What about index placement? Is the same logic applied to this? We tend to put indexes in dbspases with 16KB pages ------------------------------ Øyvind Gjerstad Developer/Architect PostNord AS ------------------------------
It is a good question and I haven't looked into it yet. 16 kB for all indices would not be a bad strategy, if that is what it does. ------------------------------ Benjamin Thompson ------------------------------