You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by sbelt <sb...@zeroton.com> on 2002/01/28 22:28:54 UTC

How to create additional indexes on my tables

I see in the Criteria HowTo for torque (outside of Turbine) that defining
indexes is supported. What is the format of this? Is there a sample
schema.xml available which demos this?

TIA,

Steve B.




--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: How to create additional indexes on my tables

Posted by Daniel Rall <dl...@finemaltcoding.com>.
"sbelt" <sb...@velos.com> writes:

> small correction...it is the "schema Reference" document that indicates this
> is possible. It just not give the info on the <index> structure.

Look at the DTD (database.dtd) -- it defines index.

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: How to create additional indexes on my tables

Posted by sbelt <sb...@velos.com>.
small correction...it is the "schema Reference" document that indicates this
is possible. It just not give the info on the <index> structure.

Steve B.

----- Original Message -----
From: "sbelt" <sb...@zeroton.com>
To: "Turbine Users List" <tu...@jakarta.apache.org>
Sent: Monday, January 28, 2002 1:28 PM
Subject: How to create additional indexes on my tables


> I see in the Criteria HowTo for torque (outside of Turbine) that defining
> indexes is supported. What is the format of this? Is there a sample
> schema.xml available which demos this?
>
> TIA,
>
> Steve B.
>
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: How to create additional indexes on my tables

Posted by Silvio Godenzi <go...@masterpoint.com>.
   <table name="TABLE_1" javaName="Table1" idMethod="native">
        <column name="ATTR_1" javaName="Attr1" type="BIGINT"
            required="true" primaryKey="true" autoIncrement="true"/>
        <index name="IDX_1">
            <index-column name="ATTR_1"></index-column>
        </index>
    </table>


Silvio Godenzi


sbelt wrote:
> 
> I see in the Criteria HowTo for torque (outside of Turbine) that defining
> indexes is supported. What is the format of this? Is there a sample
> schema.xml available which demos this?
> 
> TIA,
> 
> Steve B.
> 
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>