Playing with ALTER TABLE ... add ERKEY (s) and it appears that the 3 new indexes creations follow the table fragments. I haven't found any keywords letting me specify other dbspaces. One issue of course ... data dbspace page size typically default; some/many index dbspace page sizes are larger and much more efficient/smaller b-trees/less pages/easier tracking, etc. I suppose I COULD do an alter and move the new index to a different dbspace after creation but we're considering doing this with a large number of tables so mundane.
Still experimenting, but does anyone have any thoughts (random or otherwise) on this topic? I'm on 12.10.FC12W1.
Thanks!
Mark Scranton
mark@markscranton.com
------------------------------
Mark Scranton
------------------------------
#Informix