[Opensource] Réf. : [Opensource] Count and Key Fields

[Raul DAVIDOVICH]

As for Oracle and PostgreSQL, it works

---------------------------------------------------
Raul Davidovich
Responsable Informatique
Cvitkovic & Associés Consultants

(33) 1 45 15 40 68
(33) 1 45 15 40 41 Fax
-------------------------------------------------------
http://www.caconcology.com


|---------+------------------------------->
|         |           Michael Rimov       |
|         |           <rimovm at centercomp.c|
|         |           om>                 |
|         |           Envoyé par :        |
|         |           opensource-admin at jco|
|         |           rporate.com         |
|         |                               |
|         |                               |
|         |           30/05/2003 02:15    |
|         |           Veuillez répondre à |
|         |           opensource          |
|         |                               |
|---------+------------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |       Pour :    opensource at jcorporate.com                                                                                                        |
  |       cc :                                                                                                                                       |
  |       Objet :   [Opensource] Count and Key Fields                                                                                                |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|




There's been a discussion on SapDB mailing list that count(indexedField) is

MUCH faster than count(*).  If we change it to count the keyfields instead
of *, would this optimization apply to other databases or would it screw
them up?


-Mike


_______________________________________________
Opensource mailing list
Opensource at jcorporate.com
http://mail.jcorporate.com/mailman/listinfo/opensource
Archives: http://mail.jcorporate.com/pipermail/opensource/