Speeple News Search

Search: |

Tags | Domains | Searches | Statistics | Options | Advanced Search

pythian.com » Tags » Indexes

Related tags: group blog posts, index rebuild, internals, iot, myisam, mysql, online, ora 01450, oracle, statistics

  1. ORA-01450 During Online Index Rebuild

    Pythian Group Blog - Jul 4, 2008

    We hit an ORA-01450 error today trying to do online rebuild for an index in an unusable state. This was a non-unique index on a fairly large column — VARCHAR2(800 CHAR). SQL> alter index i1 rebuild online; alter …

    Also tagged: oracle, online, internals, group blog posts, iot, index rebuild, ora 01450

  2. MyISAM Statistics Gathering

    Pythian Group Blog - Jul 4, 2008

    So, how does one gather statistics on indexes? With InnoDB it’s one thing, with MyISAM it’s another thing. This post however, will focus on MyISAM. There are various ways, each having their own drawbacks and positive …

    Also tagged: statistics, mysql, myisam