IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

what is wrong with my indexed schema?

  • 1.  what is wrong with my indexed schema?

    Posted Thu March 17, 2005 05:25 PM

    I have an urgent problem, if someone could help. I have an XML file, which basically looks like this:

    <TEI.2>

    text value

    <TEI.2>

    </TEI.2>

    I then index the
    element with standard index in the schema as follows:
    <xs:element name = “pa”>
    xs:annotation
    xs:appinfo
    tsd:elementInfo
    tsd:physical
    tsd:native
    tsd:index
    tsd:standard/
    </tsd:index>
    </tsd:native>
    </tsd:physical>
    </tsd:elementInfo>
    </xs:appinfo>
    </xs:annotation>
    <xs:complexType mixed = “true”>
    <xs:choice minOccurs = “0” maxOccurs = “unbounded”>
    <xs:element ref = “abbr”></xs:element>
    <xs:element ref = “address”></xs:element>
    </xs:choice>
    <xs:attribute name = “corresp” type = “xs:IDREFS”></xs:attribute>
    <xs:attribute name = “synch” type = “xs:IDREFS”></xs:attribute>
    </xs:complexType>
    </xs:element>

    The problem is the performance for the text retrieval query is not improved, rather degraded a bit. And in the output from adding <?explain?> to the query, I did not see any XqcUnnestStdIdxScan element. Does this mean I did not index correctly. FYI, the query I executed is as follows:

    for $a in input()/TEI/TEI.2/body//p[contains(.“Omaha”)]
    return $a


    #API-Management
    #Tamino
    #webMethods