How to Re-indexing in magento

For category flot deta
...............................

ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;
it will work sure
...................................