forumla for index w.r.t cardinality

Posted in 2004

rkusenet — Fri, 28 May 2004 16:25:53 -0400 — source: Usenet: comp.databases.informix

For a data mart table, is there a thumb-rule for number of rows/cardinality to decide whether it is worth indexing a column or not. Basically I plan to write a script which will count the number of rows and take the cardinality and using some thumb rule will 'advise' me to create an index. TIA.