If the query plan includes an autoindex path to a large table, take it as a recommendation from the optimizer that you can improve performance by adding an index on that column. If you perform the query occasionally, you can reasonably let the database server build and discard an index. If you perform a query regularly, you can save time by creating a permanent index.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]