AS vs IS on index definition of a temp table

Posted by James Palmer on 22-Sep-2015 09:53

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? 

All Replies

Posted by Mike Fechner on 22-Sep-2015 10:00

The docs leaves this open... I consider that synonyms.

Posted by Mike Fechner on 22-Sep-2015 10:00

The docs leaves this open... I consider that synonyms.

Posted by Fernando Souza on 22-Sep-2015 10:05

There is no functional difference.

Posted by James Palmer on 22-Sep-2015 10:09

Smashing thanks both.

This thread is closed