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?
Did you define any kind of index for “SWCUSTOMERID” in the Tamino Schema ?
Yes, i tried to make an index in the key field, but it doesn’t run quicklier.