Differences
This shows you the differences between the selected revision and the current version of the page.
| wiki:spl 2010/01/26 22:24 | wiki:spl 2010/04/20 15:31 current | ||
|---|---|---|---|
| Line 18: | Line 18: | ||
| * The language is propriatory. You can't just move Informix-SPL to Oracle/Sybase/Where-ever. | * The language is propriatory. You can't just move Informix-SPL to Oracle/Sybase/Where-ever. | ||
| * Informix's new Data-Blades seem to be The Way Of The Future, so don't hold your breath waiting for new features in SPL. | * Informix's new Data-Blades seem to be The Way Of The Future, so don't hold your breath waiting for new features in SPL. | ||
| + | |||
| ===== When are Stored Procedures optimized? ===== | ===== When are Stored Procedures optimized? ===== | ||
| Line 27: | Line 28: | ||
| If "update statistics for table" is run for any table involved in the query, the SQL statement will be re-optimized the next time the stored procedure is executed. | If "update statistics for table" is run for any table involved in the query, the SQL statement will be re-optimized the next time the stored procedure is executed. | ||
| + | ===== Dynamic SPL ===== | ||
| + | |||
| + | |||
| + | [[http://www.ibm.com/developerworks/data/library/techarticle/dm-0806mottupalli/index.html|Dynamic SPL]] | ||
