Re: Unique index ??

Posted in 2005

Mark D. Stock — Thu, 03 Feb 2005 23:39:29 +0000 — source: Usenet: comp.databases.informix

Obnoxio The Chav wrote: > Dirk Moolman said: > >>I am having an argument with one of our developers. He wants me to >>create the following (unique) index on a new table. This just sounds >>ridiculous to me. >> >>Any comments / suggestions ? > > > A swift "bitch slap", I think. > > >>create unique index "stanley".iu_dao on "stanley".done_and_out >> >> (dao_scheme_chk,dao_category_chk,dao_operator_chk,dao_status_chk, >> dao_dt_from_chk,dao_dt_to_chk,dao_ta_code_chk,dao_rule_chk, >> >>dao_iteration_chk,dao_rej_code_chk,dao_batch_type_chk,dao_dr_type_chk, >> dao_units_chk,dao_clm_amt_chk,dao_tar_amt_chk,dao_ben_amt_chk); Mmm, for once I think Obnoxio is being far too lenient. I often take such developers out back and give them a good kicking. It doesn't seem to improve their database design skills, but it makes me feel MUCH better. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list

↪ replying to Mark D. Stock

Data Goob — Fri, 04 Feb 2005 08:01:16 -0500 — source: Usenet: comp.databases.informix

You should probably bitch slap your website admin because the URL to your website brings up an error page. Not Found The requested URL / was not found on this server. ( http://MydasSolutions.com ) 8o) Mark D. Stock wrote: > Obnoxio The Chav wrote: > > >>Dirk Moolman said: >> >> >>>I am having an argument with one of our developers. He wants me to >>>create the following (unique) index on a new table. This just sounds >>>ridiculous to me. >>> >>>Any comments / suggestions ? >> >> >>A swift "bitch slap", I think. >> >> >> >>>create unique index "stanley".iu_dao on "stanley".done_and_out >>> >>> (dao_scheme_chk,dao_category_chk,dao_operator_chk,dao_status_chk, >>> dao_dt_from_chk,dao_dt_to_chk,dao_ta_code_chk,dao_rule_chk, >>> >>>dao_iteration_chk,dao_rej_code_chk,dao_batch_type_chk,dao_dr_type_chk, >>> dao_units_chk,dao_clm_amt_chk,dao_tar_amt_chk,dao_ben_amt_chk); > > > Mmm, for once I think Obnoxio is being far too lenient. I often take such > developers out back and give them a good kicking. It doesn't seem to > improve their database design skills, but it makes me feel MUCH better. ;-) > > Cheers,