SqlDbx
You are not logged in.
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
You make a good point.
I think we can add index-type to the CREATE INDEX statement
Offline
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