What do you want from IQ

[Former Member]

Dear colleagues, customers, dba, gurus of IQ.

What do you want from SAP (Sybase) IQ to feel happy.

Ideas please.

[Former Member]

IQ - Supporting index partitioning.

Now IQ support partially.

[Former Member]

"Push the limits".

IQ

Physical Limitations - Audience - SAP Library

Vertica

https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemLimits.htm%3FToc...

[Former Member]

change licensing politics - remove additional options like unstructured data or table partitioning And etc..

All "options" must be include in enterprise edition without any additional fee.

its stopped IQ distribution. Vertica in the hall.

[Former Member]

Totally agree.

[Former Member]

4. Add support 16-bit or 32-bit character sets such as UTF-16 or UTF-32.

Now (IQ 16 SP03) - SAP Sybase IQ does not support 16-bit or 32-bit character sets such as UTF-16 or UTF-32.

SyBooks Online

[Former Member]

3. SQL - Upsert operator

REPLACE | UPSERT - SQL Reference - SAP Library

[Former Member]

More open information about it internals. 

[former_member191072]

- sp_iqtablesize(ALL) / sp_tablesize('<username>.*')

- Sybase central or simular GUI based tool. Not webbased tool .

[Former Member]

Sybase central removed in IQ 16 as i understand.

[Former Member]

integration with HANA.

2. IQ administration in HANA Studio.

(Current SAP Control Center writing on Adobe Flash - extremely slow (as everything on Flash) and non user friendly)

[Former Member]

1. SQL  - MINUS operator

like in Oracle RDBMS

http://www.techhoney.com/oracle/sql/minus-in-oracle-sql-plsql/