Update Cost Based Optimizer docs section "Preferring the nearest index" to describe new reality

[rmloveland]

We still have this huge section in the optimizer docs on Preferring the nearest index, which needs to be updated since it refers to Ye Olde "duplicate indexes" and has a bunch of explicit zone configs n stuff.

Options for dealing with this include:

• Replace it with a section called "multi-region index selection" or similar?
• Remove it altogether? Since maybe users get this all "for free" now from the optimizer when they add indexes to tables in multi-region DBs? Is it enough to rely on the index change descriptions in Add docs on indexing of REGIONAL BY ROW tables #10280?
• ???
• profit, etc.

[rmloveland]

Hey @ianjevans since (I think?) you are the optimizer docs person (?) - FYI I am planning some updates to this section of the page re: multi-region things

[ianjevans]

I've got some updates to this page forthcoming in #10324, but I don't think they affect that section. It should be merged in the next day or two.

[rmloveland]

Ian Evans ***@***.***> writes:

I've got some updates to this page forthcoming in #10324, but I don't think they affect that section. It should be merged in the next day or two.

ACK - thanks!

[rmloveland]

Went with the 2nd option - remove altogether (in #10465), since you now get this behavior automagically from multi-region databases.

Closing ...