Difference between revisions of "ICACHE()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return optimum ICACHE size for a given index expression | Function to return optimum ICACHE size for a given index expression | ||
| Line 34: | Line 30: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Indexing]] | ||
| + | [[Category:Indexing Functions]] | ||
Latest revision as of 16:26, 2 December 2009
Purpose
Function to return optimum ICACHE size for a given index expression
Syntax
ICACHE(<exp>[, <expN>])
See Also
INDEX, REINDEX, SET DCACHE, SET ICACHE
Description
The ICACHE() function returns the optimum size of the index buffer cache for an index created on the specified expression. The <exp> can either be a numeric value representing the width of the index key, or the index expression. This function is used in conjunction with the SET ICACHE TO command. The command SET ICACHE TO OPTIMUM can be used instead of the ICACHE() function to automate defining index buffer caches.
If the optional <expN> is specified and is greater than zero (0), the required memory allocation is returned.
Example
use names index names size = icache(indexkey(1)) set icache to size reindex use names set icache to icache(name+left(address, 5)) index on name+left(address, 5) to names
Products
Recital Server, Recital
