The idea is the following.
Have products and services that pass through different states (order, committed, reviewed, approved, slope, bill, invoice), these may belong to a period or many (period = months).
Have products and services that pass through different states (order, committed, reviewed, approved, slope, bill, invoice), these may belong to a period or many (period = months).
The filter may include the client query or not.
La idea es la siguiente.
Tengo productos y servicio que pasan por distintos estados (pedido, comprometido,revisado, aprovado, pendiente, a facturar, facturado), estos pueden pertenecer a un periodo o a muchos (periodo=meses).
El filtro del query puede incluir el cliente o no.
Tengo productos y servicio que pasan por distintos estados (pedido, comprometido,revisado, aprovado, pendiente, a facturar, facturado), estos pueden pertenecer a un periodo o a muchos (periodo=meses).
El filtro del query puede incluir el cliente o no.
El Miércoles, 3 de febrero, 2016 12:23:31, "Thomas Steinmaurer ts@iblogmanager.com [firebird-support]" <firebird-support@yahoogroups.com> escribió:
> 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?
Hard to say without seeing an actual query ...
Is the state field the only one used to filter the result set?
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
> 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?
Hard to say without seeing an actual query ...
Is the state field the only one used to filter the result set?
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
__._,_.___
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 (3) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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