M
Marian Edu
Guest
best documentation is probably that no one even need 
now that the abl was more a move to the 3-rd than 4-th generation languages wonder how a database that doesn't need any indexes defined (let aside the primary key and other unique constraints) would look like... while might still be true a progress database can run with no dba (at least not full-time) the performance is often impacted by poor database design. thing is, you're clever guys so why not a 4gl alike database that can add/remove indexes as needed... see constant filters on some fields add a new index to avoid full table scan for those, other indexes (again, not unique) that are used only once a year go ahead ad drop them. that can be more than just a cost base optimizer although that would definitively be a great step toward, especially given the usage of dynamic queries... late already here so not just a day time dream
Continue reading...
now that the abl was more a move to the 3-rd than 4-th generation languages wonder how a database that doesn't need any indexes defined (let aside the primary key and other unique constraints) would look like... while might still be true a progress database can run with no dba (at least not full-time) the performance is often impacted by poor database design. thing is, you're clever guys so why not a 4gl alike database that can add/remove indexes as needed... see constant filters on some fields add a new index to avoid full table scan for those, other indexes (again, not unique) that are used only once a year go ahead ad drop them. that can be more than just a cost base optimizer although that would definitively be a great step toward, especially given the usage of dynamic queries... late already here so not just a day time dream Continue reading...