Speed with Native Schema

, ,
1

Hi everybody!

I have a Native Schema with 500,000 docs. A query (SW_CUSTOMER [SWCUSTOMERID = 4668]) against this schema is too slow.

Though, this query in a schema mapped to Oracle is very fast. I think it happened because the table in Oracle use indexes that makes the query faster.

Does anybody knows how can I define my Native Schema or the Database in order to resolve this speed problem?

Thanks.

2

Did you define any kind of index for “SWCUSTOMERID” in the Tamino Schema ?

3

Yes, i tried to make an index in the key field, but it doesn’t run quicklier.