Re: Naming Convention for Informix Database Objects

Posted in 2003

Richard Kofler — Fri, 21 Nov 2003 20:37:00 GMT — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: > > Dusty Haas wrote: > > > Shouldn't indices be - this_is_an_index_called_ instead of a_index_? > > > > Just a curious thought > > You're quite right to do that nit pick > and I do feel just like a right dick > your razor sharp eyes > affirm the surmise > "to cut and paste is lazy and thick" Justy is right - almost. you need at least 2 different praefixes (and their variations) this_is_an_unique_index_(not_)used_as_primary_key_later_on_after_we_done_with_alter_table_ this_is_a_compound_index-....... and so on. Of course when IFX dev ppl are done with auto change of praefix_part_of_index_name when you insert into a table with a cluster index in such a way, that is is no more truely clustered, they might concentrate on indexes having an entry lenth of greater than 16 TeraByte I hope this answeres another posting I had to read today dic_k PS: if you do not stop top posting, I might turn on my HTML feature here :) this is usenet & if you want to learn about netiquette the rough way, then TOFU post into a more fundamentalistic group like clpm. This is still the fastest way to learn all about links to netiquette -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe

↪ replying to Richard Kofler

Obnoxio The Clown — Fri, 21 Nov 2003 21:11:15 +0000 — source: Usenet: comp.databases.informix

Richard Kofler wrote: > Obnoxio The Clown wrote: >> >> Dusty Haas wrote: >> >> > Shouldn't indices be - this_is_an_index_called_ instead of a_index_? >> > >> > Just a curious thought >> >> You're quite right to do that nit pick >> and I do feel just like a right dick >> your razor sharp eyes >> affirm the surmise >> "to cut and paste is lazy and thick" > > Justy is right - almost. > you need at least 2 different praefixes (and their variations) > > this_is_an_unique_index_(not_)used_as_primary_key_later_on_after_we_done_with_alter_table_ > this_is_a_compound_index-....... > > and so on. > > Of course when IFX dev ppl are done with auto change of > praefix_part_of_index_name > when you insert into a table with a cluster index in such a way, that > is is no more > truely clustered, they might concentrate on indexes having an entry > lenth of > greater than 16 TeraByte > > I hope this answeres another posting I had to read today > > dic_k > > PS: if you do not stop top posting, I might turn on my HTML feature > here :) > this is usenet & if you want to learn about netiquette the rough > way, then > TOFU post into a more fundamentalistic group like clpm. > This is still the fastest way to learn all about links to > netiquette Where did I top post? -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche

↪ replying to Obnoxio The Clown

Richard Kofler — Sat, 22 Nov 2003 00:03:15 GMT — source: Usenet: comp.databases.informix

Obnoxio The Clown wrote: [ ... stuff snipped .. ] > Where did I top post? > I apologize. You did not top post. I must learn all about that buttons scrolling down the pages .... The good thing is: I will not use HTML (for now :) dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe

↪ replying to Richard Kofler

Obnoxio The Clown — Sun, 23 Nov 2003 15:31:12 +0000 — source: Usenet: comp.databases.informix

Richard Kofler wrote: > Obnoxio The Clown wrote: > > [ ... stuff snipped .. ] > >> Where did I top post? >> > > I apologize. > You did not top post. > I must learn all about that buttons scrolling down the pages .... > > The good thing is: I will not use HTML (for now :) Just as well, too. I would have hated to humiliate you twice in a public forum. :o) -- "C'est pas parce qu'on n'a rien ''' dire qu'il faut fermer sa gueule" - Coluche