Hi, This discussion sounds a lot like dynamic segmentation that is used by ESRI and Oracle. See for example this: http://www.esri.com/library/whitepapers/pdfs/lrds_arcgis.pdf Professionals using dynamic segmentation could for sure tell their opinions about the pros and cons of it. Unfortunately those professionals don't necessarily read this mailing list.