This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:indexing:creation:declaring [2012/01/26 16:16] doc |
admin:indexing:creation:declaring [2012/03/02 20:20] doc |
||
---|---|---|---|
Line 4: | Line 4: | ||
====== Administration: Omnidex Indexing ====== | ====== Administration: Omnidex Indexing ====== | ||
- | ===== Indexing Creation ===== | + | ===== Index Creation ===== |
[[admin:indexing:creation:home|Overview]] | | [[admin:indexing:creation:home|Overview]] | | ||
**[[admin:indexing:creation:declaring|Declaring Indexes]]** | | **[[admin:indexing:creation:declaring|Declaring Indexes]]** | | ||
[[admin:indexing:creation:updating|Updating Indexes]] | | [[admin:indexing:creation:updating|Updating Indexes]] | | ||
- | [[admin:indexing:creation:standalone|Standalone Indexes]] | | ||
[[admin:indexing:creation:files|Index Files]] | | [[admin:indexing:creation:files|Index Files]] | | ||
- | [[admin:indexing:creation:updating|Maintenance]] | + | [[admin:indexing:creation:performance|Performance]] |
+ | ---- | ||
==== Declaring Indexes ==== | ==== Declaring Indexes ==== | ||
Line 70: | Line 69: | ||
</code> | </code> | ||
- | Most commonly, administrators have an [[admin:basics:environments:home|Omnidex Environment File]] that contains all CREATE TABLE and CREATE INDEXES for their database. This SQL file can then be run using OdxSQL, regenerating the Environment File. Once the revised indexing has been declared, the indexes can be [[admin:indexing:creation:updating|updated]]. | ||
==== ==== | ==== ==== | ||