This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:indexing:activecounts:tips [2011/01/22 23:01] els |
admin:indexing:activecounts:tips [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 23: | Line 25: | ||
| * The most important step in setting up ActiveCounts on a database is insuring that all statements are going to be completely optimized using Omnidex indexing. It is worthwhile to obtain a [[admin:optimization:plans:home|query plan]] for each query to insure that it is fully optimized. | * The most important step in setting up ActiveCounts on a database is insuring that all statements are going to be completely optimized using Omnidex indexing. It is worthwhile to obtain a [[admin:optimization:plans:home|query plan]] for each query to insure that it is fully optimized. | ||
| - | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to present the column used as the grid's [[admin:features:grids:partition|Partition Qualifier]] first. Once the Partition Qualifier has been provided, the scope of the searches is substantially reduced. | + | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to present the column used as the grid's [[admin:features:grids:partitions|Partition Qualifier]] first. Once the Partition Qualifier has been provided, the scope of the searches is substantially reduced. |
| - | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to have [[admin:features:rollups:home|Rollup Tables]] on each node, and also have Rollup Tables on a [[admin:features:grids:rollups|Rollup Node]]. | + | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to have [[admin:features:rollups:home|Rollup Tables]] on each node, and also have Rollup Tables on a Rollup Node. |