I have a state machine (workflow) implemented on a table a couple of million records and growing.
I have crated an index on the "state" field. The possible states are very few (5 to 10). Obviously selectivity index is terrible. As I can optimize the query?
I have crated an index on the "state" field. The possible states are very few (5 to 10). Obviously selectivity index is terrible. As I can optimize the query?
thank
Tengo una máquina de estados (workflow) implementado sobre una tabla de un par de millones de registros, y creciendo.
Tengo creado un indice sobre el campo "estado". Los estados posibles son muy pocos ( de 5 a 10 ). Obviamente la selectividad del indice es pésima. Como puedo optimizar la consulta?
Tengo creado un indice sobre el campo "estado". Los estados posibles son muy pocos ( de 5 a 10 ). Obviamente la selectividad del indice es pésima. Como puedo optimizar la consulta?
Gracias
__._,_.___
Posted by: =?UTF-8?Q?Germ=C3=A1n_Balbi?= <balger@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment