When does MaxDB use Index strategy?

[Former Member]

Hello,

I want to improve the performance of my MaxDB. So I tried to create indexes and now I want to check if these indexes are used or not!

1st: Is there a possibility to force MaxDB to use the index, if the sql statement consists e.g. LIKE '%N600%'?

2nd: Exist a list or something else where I can see which sql statements in MaxDB dont support index strategy?

Thx for help and kind regards,

Frank

[Melanie · Accepted solution]

Hello Frank,

A1: You could force MaxDB to use an index - but this wouldn't help much. The index could not be used efficiently with a like condition which starts with %.

Q2: Please check out the tuning section in the Wiki:

https://wiki.sdn.sap.com/wiki/x/jRI

Especially this section might be of interest for you:

https://wiki.sdn.sap.com/wiki/x/GXE

In General: if you want to check the execution plan for a specific SQL statement, use the EXPLAIN statement (just add EXPLAIN before the SELECT and execute it in SQLStudio).

HTH,

Melanie