Difference between revisions of "Optimizing Indexes using SYNCNUM"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
Recital Character and date indexes are optimized based on the use of the pseudo column [[SYNCNUM]] to ensure that all keys are unique. Every row/record in a table has a unique [[SYNCNUM]] value for that table. | Recital Character and date indexes are optimized based on the use of the pseudo column [[SYNCNUM]] to ensure that all keys are unique. Every row/record in a table has a unique [[SYNCNUM]] value for that table. | ||
| − | The optimization is enabled in Recital 10. Any new character or date indexes include the [[SYNCNUM]] column automatically: character indexes have [[SYNCNUM]] added to the end of the expression, date indexes are converted to [[DTOS()]] and have the [[SYNCNUM]] added to the end. Numeric index are not affected. | + | The optimization is enabled in Recital 10. Any new character or date indexes include the [[SYNCNUM]] column automatically: character indexes have [[SYNCNUM]] added to the end of the expression, date indexes are converted to [[DTOS()]] and have the [[SYNCNUM]] added to the end. Numeric index are not affected. |
| − | The | + | The index for existing Recital tables from earlier versions should be rebuilt ([[INDEX]]) for use in Recital 10. The rebuild will add the [[SYNCNUM]] to the key. |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
Latest revision as of 11:07, 5 October 2010
Recital Character and date indexes are optimized based on the use of the pseudo column SYNCNUM to ensure that all keys are unique. Every row/record in a table has a unique SYNCNUM value for that table.
The optimization is enabled in Recital 10. Any new character or date indexes include the SYNCNUM column automatically: character indexes have SYNCNUM added to the end of the expression, date indexes are converted to DTOS() and have the SYNCNUM added to the end. Numeric index are not affected.
The index for existing Recital tables from earlier versions should be rebuilt (INDEX) for use in Recital 10. The rebuild will add the SYNCNUM to the key.
