Re: help: optimizer can't use index on Y to speed up select .. sum(X) ... group by Y

From: Jay Krishnamurthy <76326,712_at_compuserve.com>
Date: 1995/08/24
Message-ID: <41iss0$o2g_at_data.interserv.net>#1/1

Maybe I am missing something here. Table T1 has key and value fields, indexed on key. You are doing a SUM that requires an entire table read. It may be faster to do a sequential read than going thru the index ??? Received on Thu Aug 24 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Saad Ahmad: "Re: Where clause ordering"
Previous message: Karl Penney: "Re: SQL*PLUS Syntax for Concatenation"
In reply to: Reinhard Kuhn: "help: optimizer can't use index on Y to speed up select .. sum(X) ... group by Y"
Next in thread: Saad Ahmad: "Re: Where clause ordering"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message