SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-01-23 05:19:50

scottinet
Member

Scripting does not generate index type

Hi,

In Sybase IQ, there are special index types, mainly depending on the column type and the amount of different values a column may contain (more info here : http://infocenter.sybase.com/help/index … 40877.html )

In short, the create index statement contains an additional parameter :
   CREATE [unique] [index-type] INDEX ...

(as you can see, there is no "[non]clustered" notion in Sybase IQ either)

The command sp_iqhelp shows these index types :
sp_iqhelp <table>

index_name    column_name index_type  unique_index    location    remarks
==========  =========== =========== =========== =========== ===========
AsOfDate_Index  AsofDate    DATE        N       Main    
AsofDateLF  AsofDate    LF      N       Main    
Book_Index  IdBook      HG      N       Main    
...

When using the scripting option to generate a table DDL with sqldbx, the index type is not present, meaning that a HG index will be created by default.
Is it possible/planned to add the index type to the scripting index feature?

Thanks,

Offline

#2 2013-01-23 17:39:37

sqldbxhelp
Administrator

Re: Scripting does not generate index type

You make a good point.
I think we can add index-type to the CREATE INDEX statement

Offline

#3 2013-05-17 04:47:41

scottinet
Member

Re: Scripting does not generate index type

Hi,

I'm a bit late, but Sybase IQ indexes are correctly supported since the 3.6 version.

Thanks A LOT for this update. :-)

Last edited by scottinet (2013-05-17 04:49:02)

Offline

Board footer

Powered by FluxBB