Subject | Re: How to get a good performance |
---|---|
Author | donoteatcarrot |
Post date | 2005-11-25T13:35:11Z |
Hi, Thank you.
below:
CREATE INDEX IX_A ON TABLE_X (field_A);
CREATE DESC INDEX IX_A_DE ON TABLE_X (field_A);
but seems not worked.
The execution will still take as long time as before.
and so is memory usage.
> What about the performance in FB with your original SELECT MAX...I added both index and desc index to that field, using the command
> after adding DESC index? And memory usage with FB?
below:
CREATE INDEX IX_A ON TABLE_X (field_A);
CREATE DESC INDEX IX_A_DE ON TABLE_X (field_A);
but seems not worked.
The execution will still take as long time as before.
and so is memory usage.