ALTER TABLE `jos_categories` ADD INDEX `idx_alias` ( `alias` );
ALTER TABLE `jos_categories` ADD INDEX `idx_ordering` ( `ordering` );
ALTER TABLE `jos_categories` ADD INDEX `idx_checkouttime` ( `checked_out_time` );
ALTER TABLE `jos_categories` ADD INDEX `idx_title` ( `title` );
ALTER TABLE `jos_categories` ADD FULLTEXT `idx_description` ( `description` );
ALTER TABLE `jos_categories` ADD INDEX `idx_published` ( `published` ); 

ALTER TABLE `jos_sections` ADD INDEX `idx_alias` ( `alias` );
ALTER TABLE `jos_sections` ADD INDEX `idx_ordering` ( `ordering` );
ALTER TABLE `jos_sections` ADD FULLTEXT `idx_description` ( `description` ) ;
ALTER TABLE `jos_sections` ADD INDEX `idx_checkout` ( `checked_out` );
ALTER TABLE `jos_sections` ADD INDEX `idx_name` ( `name` );
ALTER TABLE `jos_sections` ADD INDEX `idx_title` ( `title` );
ALTER TABLE `jos_sections` ADD INDEX `idx_published` ( `published` );
ALTER TABLE `jos_sections` ADD INDEX `idx_checkouttime` ( `checked_out_time` );
ALTER TABLE `jos_sections` ADD INDEX `idx_access` ( `access` );
ALTER TABLE `jos_sections` ADD INDEX `sec_idx` ( `published` , `access` );

ALTER TABLE `jos_content` ADD INDEX `idx_checkouttime` ( `checked_out_time` );
ALTER TABLE `jos_content` ADD FULLTEXT `idx_introtext` ( `introtext` );
ALTER TABLE `jos_content` ADD FULLTEXT `idx_cfulltext` ( `fulltext` );
ALTER TABLE `jos_content` ADD INDEX `idx_ordering` ( `ordering` );
ALTER TABLE `jos_content` ADD INDEX `idx_title` ( `title` );
ALTER TABLE `jos_content` ADD INDEX `idx_alias` ( `alias` ); 
ALTER TABLE `jos_content` ADD INDEX `idx_publishup` ( `publish_up` );
ALTER TABLE `jos_content` ADD INDEX `idx_publishdwn` ( `publish_down` );
ALTER TABLE `jos_content` ADD INDEX `idx_titlealias` ( `title_alias` );

ALTER TABLE `jos_content_frontpage` ADD INDEX `idx_ordering` ( `ordering` );