CREATE INDEX "ST_TGT_FK_I"
ON SERVICETICKET ("TICKETGRANTINGTICKET_ID")
CREATE INDEX "TGT_TGT_FK_I"
ON TICKETGRANTINGTICKET ("TICKETGRANTINGTICKET_ID")
Is this enough? Or do I need COMPUTE STATISTICS?
-----Mensagem original-----
De: Marvin Addison [mailto:[email protected]]
Enviada: quinta-feira, 3 de Fevereiro de 2011 12:25
Para: [email protected]
Assunto: Re: [cas-user] JpaTicketRegistry
Using http://dev.mysql.com/doc/refman/5.5/en/create-index.html as a
guide, should be easy to translate the Oracle DDL you cited to MySQL.
If someone is already using MySQL and has done this, please speak up.
M
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
---
Hi everyone,
Anyone using MySQL as their Jpa Ticket Registry DB? How can I create the
indexes to avoid deadlocks in Mysql?
CREATE INDEX "ST_TGT_FK_I"
ON SERVICETICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
/** Create index on TGT self-referential foreign-key constraint */
CREATE INDEX "TGT_TGT_FK_I"
ON TICKETGRANTINGTICKET ("TICKETGRANTINGTICKET_ID")
COMPUTE STATISTICS;
Source: https://wiki.jasig.org/display/CASUM/JpaTicketRegistry
Thank you,
Francisco
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
--
You are currently subscribed to [email protected] as:
[email protected]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
