zainengineer

<?php
// Decoded HTML for http://www.eschrade.com/page/indexing-in-magento-or-the-wonderful-world-of-materialized-views/

$logTable = Mage::getModel('log/log')->getResource()->getTable('url_table');

//Separator

$pkData = $this->_conn->getIndexList($logTable);
if (!isset($pkData['PRIMARY']['COLUMNS_LIST'][0])) {
    Mage::throwException('Unable to find log table primary key');

zainengineer

<?php
umask(0);
require 'app/Mage.php';

Mage::setIsDeveloperMode(true);
error_reporting(E_ALL);
ini_set('display_errors', 1);
set_time_limit(0);

Mage::app();