ALTER TABLE for table indexing:Example
ALTER TABLE `listing` ADD INDEX `idx_uid_type` ( `uid` , `listing_type` ) ; ALTER TABLE `users` ADD INDEX ( `email` ) ; ALTER TABLE `listing_reply` ADD INDEX ( `listingid` , `uid` , `parent_listing` ) ;
satishgaudo.com
Understanding technology
Posts Tagged 'mysql table indexing'