Looking at the help (v11.5.1) I see that on a temp-table definition you can define an index with AS or IS
INDEX index-name [ [ AS | IS ] [ UNIQUE ] [ PRIMARY ] [ WORD-INDEX ] ]
I was wondering if there is a functional difference between the two, or are they synonyms?
The docs leaves this open... I consider that synonyms.
The docs leaves this open... I consider that synonyms.
There is no functional difference.
Smashing thanks both.