DB clustering INDX table

[Former Member]

Hello,

I have couple of internal table with good amount of data. I am planning to export it to INDX and then IMPORT it whenever needed. My questions

How I can fetch only one record that is needed.

Other wise I have to get entire itab into memory and then read using read table statement. I read somewhere that we can use SELECT statement on it but I could not find any reference to it. Can we use SELECT on it and if yes how?

Thanks in advance.

[Former Member]

Hello,

I have couple of internal table with good amount of data. I am planning to export it to INDX and then IMPORT it whenever needed. My questions

How I can fetch only one record that is needed.

Other wise I have to get entire itab into memory and then read using read table statement. I read somewhere that we can use SELECT statement on it but I could not find any reference to it. Can we use SELECT on it and if yes how?

Thanks in advance.

[Former Member]

Any inputs on this are welcome!!!

[Former Member]

Closing , but not answered

[Former Member]

These Links might help you.

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3c1f358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_470/helpdata/en/fc/eb3c2c358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_470/helpdata/en/fc/eb3c53358411d1829f0000e829fbfe/content.htm

There is sample program included.