>>>>> "Rod" == Rod Taylor <[EMAIL PROTECTED]> writes:

  Rod> On Wed, 2005-03-16 at 18:58 +0100, Laurent Martelli wrote:
  >> Consider this query:
  >> SELECT distinct owner from pictures;

  Rod> The performance has nothing to do with the number of rows
  Rod> returned, but rather the complexity of calculations and amount
  Rod> of data to sift through in order to find it.

Yes, but I thought that an index might be able to know what distinct
values there are and help optime that query very much.

Laurent Martelli
[EMAIL PROTECTED]                                Java Aspect Components
http://www.aopsys.com/                          http://jac.objectweb.org

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to