Index creation in MaxDB

[Former Member]

Hello,

I have to create a bitmap index in MaxDB.

Can do I connect to MaxDB database from sqlcli tool and then create a bitmap index in MaxDB?

Can anyone provide me the syntax, steps, or a URL.

Thanks,

[lbreddemann · Accepted solution]

> I have to create a bitmap index in MaxDB.

Hi there!

MaxDB does not know bitmap indices - it's simply not possible to apply this technology to the data storage MaxDB employs.

Bitmap indexes represent the location of data referred to their value.

For each distinct value of the indexed column a bitmap index holds a bitmap denoting the database blocks in which those rows can be found that have the value for that column.

Since MaxDB moves blocks/pages around all the time and (via the b*tree maintenance operations) also moves data in-between pages, a fixed map of blocks - like a bitmap index - would be of no use.

The question here is: why do you think that you need such a bitmap index in MaxDB?

regards,

Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your valuable update.

I am creating bitmap index on MaxDB because we have implemented GRC AC 5.3 on MaxDB. We have AS JAVA stack installed as per the GRC requirement and we do not have the ABAP stack.

We are following OSS Note 1044174, for performance tuning of GRC jobs on MaxDB Database, which gives the following syntax

CREATE BITMAP INDEX IX_VIRSA_CC_PRMVL ON VIRSA_CC_PRMVL (JOBID, GENOBJID,

GENOBJTP, VSYSKEY) LOGGING

My query is how do I logon to command line in MaxDB and through which tool i.e. dbmcli or sqlcli or some other tool should I create the index and execute the above syntax.

Thanks,

Haleem

[lbreddemann · Accepted solution]

> We are following OSS Note 1044174, for performance tuning of GRC jobs on MaxDB Database, which gives the following syntax

Sorry, but you're not reading the note properly.

It's for Oracle 10g only !

Even the shorttext of the note says :"Note 1044174 - Recommendation for CC 5.x running on Oracle 10G Database"...

regards,

Lars

[Former Member · Accepted solution]

Yes, that is true that the note is for Oracle.

But still I need to create a index in MaxDB. If MaxDB does not allow Bitmap index, then I can create a B Tree index.

[lbreddemann · Accepted solution]

> But still I need to create a index in MaxDB. If MaxDB does not allow Bitmap index, then I can create a B Tree index.

And you know that because of ...?

See, indexes differ a lot between different DBMSes - especially between Oracle and MaxDB.

So, a far better approach would be:

Have your slow running SQL statement analyzed by support.

Then you'll get a (when this is really the solution to your problem) a note that fully explains what to do with MaxDB in this case.

regards,

Lars

[Former Member]

hello,

Here is a concrete example using the demo data:

http://maxdb.sap.com/doc/7_7/44/e35bf7009303fbe10000000a1553f6/content.htm

The above is a link to the maxDB 7.7 online doc.

[Former Member]

Hi,

Go through the below links talking all about Indexing...

[http://www.bw2048.com/faq-sap-maxdb-indexes-303.htm|http://www.bw2048.com/faq-sap-maxdb-indexes-303.htm]

and

[http://www.sapdb.org/7.4/htmhelp/6d/117c4dd14811d2a97400a0c9449261/content.htm|http://www.sapdb.org/7.4/htmhelp/6d/117c4dd14811d2a97400a0c9449261/content.htm]

Above links may be of your help...

Regards.

Rajesh Narkhede