EXTEND USING option of CREATE INDEX command

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

efiryago@gmail.com - 18 Dec 2005 03:23 GMT

Can someone clarify what is EXTEND USING option in the CREATE INDEX
command for, what kind of index structure it creates? Is it a new
feature introduced in FP10, or it's been around for awhile yet?

Thanks,
-Eugene

Reply to this Message

Mark A - 18 Dec 2005 03:40 GMT

> Can someone clarify what is EXTEND USING option in the CREATE INDEX
> command for, what kind of index structure it creates? Is it a new
> feature introduced in FP10, or it's been around for awhile yet?
>
> Thanks,
> -Eugene

It is not new to FP 10 and I believe it is availble in 8.1.

This clause uses an index-extention-name. For more information, see CREATE
INDEX EXTENSION in the SQL Reference Vol 2. I think that will provide the
explanation you are looking for.

Reply to this Message

Knut Stolze - 19 Dec 2005 07:59 GMT

>> Can someone clarify what is EXTEND USING option in the CREATE INDEX
>> command for, what kind of index structure it creates? Is it a new
>> feature introduced in FP10, or it's been around for awhile yet?
>>
> It is not new to FP 10 and I believe it is availble in 8.1.

That's available since V7.1 FP1 (or even V7.1 GA).

> This clause uses an index-extention-name. For more information, see CREATE
> INDEX EXTENSION in the SQL Reference Vol 2. I think that will provide the
> explanation you are looking for.

Originally, this was introduced as part of the DB2 engine work for the DB2
Spatial Extender that needed a more specialized indexing method. You have
to define the indexing method, i.e. the index extension, and with the
EXTEND USING clause you say which index extension along which parameters
shall be used. Another write-up on index extensions can be found here:
http://tinyurl.com/8y8yb I hope it explains how index extensions work.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

efiryago@gmail.com - 19 Dec 2005 16:01 GMT

I just hit this clause when was checking with the general syntax for
CREATE INDEX command so, not having any experience with the feature
like DB2 Spatial it's serving for, just fired that curiosity question
to the group, so thank you guys for your hints.

-Eugene

Reply to this Message