Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Larry,
>
>>> I'm a real supporter of the KISS concept :) My indexing schemes are always confined to INDEX ON ??? TAG ??? commands... no descending,
> unique, candidate, primary, etc... qualifiers. <<
>
>I have to agree 100%.....
>
>...except I would look closely at PRIMARY, it is well worth looking at.
Actually, I have looked at it ( a little :) ) and my reason for avoiding it is that APPEND BLANK violates the key's 'uniqueness' and so triggers an error. Lately, though I haven't been using the APPEND BLANK method, so maybe I'll revisit this issue.
I'm sure all the other settings have their purposes as well... but I won't use anything in production until I understand it fully.
Thanks
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement