Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
admin:indexing:creation:updating [2012/01/30 16:54]
doc
admin:indexing:creation:updating [2016/06/28 22:38] (current)
Line 4: Line 4:
 ====== Administration:​ Omnidex Indexing ====== ====== Administration:​ Omnidex Indexing ======
  
-===== Indexing ​Creation =====+===== Index Creation =====
  
 [[admin:​indexing:​creation:​home|Overview]] | [[admin:​indexing:​creation:​home|Overview]] |
Line 11: Line 11:
 [[admin:​indexing:​creation:​files|Index Files]] | [[admin:​indexing:​creation:​files|Index Files]] |
 [[admin:​indexing:​creation:​performance|Performance]] [[admin:​indexing:​creation:​performance|Performance]]
 +----
 ==== Updating Indexes ==== ==== Updating Indexes ====
  
Line 50: Line 50:
  
 <​code>​ <​code>​
-> update indexes for index STATE_CITY_ZIP+> update indexes for index HOUSEHOLDS.STATE_CITY_ZIP;
 Database Database
  ​Table ​                                      ​Rows ​       CPU    Elapsed  ​Table ​                                      ​Rows ​       CPU    Elapsed
 ---------------------------------------------------------------------------- ----------------------------------------------------------------------------
 SIMPLE SIMPLE
- ​HOUSEHOLDS ​                                ​1,​909 ​      ​0:​00 ​      0:00 + ​HOUSEHOLDS ​                                ​1,​909 ​      ​0:​00 ​      0:03
- ​INDIVIDUALS ​                               5,000       ​0:​00 ​      0:00+
 ---------------------------------------------------------------------------- ----------------------------------------------------------------------------
-Total                                                   ​0:​00 ​      0:03+Total                                                   ​0:​00 ​      0:04
  
-Omnidex indexes ​updated+Index (HOUSEHOLDS)HOUSEHOLDS.STATE_CITY_ZIP ​updated
 > >
 </​code>​ </​code>​
- 
- 
- 
- 
 ====  ====  ====  ==== 
  
 
Back to top
admin/indexing/creation/updating.1327942498.txt.gz · Last modified: 2016/06/28 22:38 (external edit)