General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only