On 12 Jan 2011, at 15:12, Vander Clock Stephane wrote:
> before it's return in 100 ms now 30 secondes :(
>
> What i do wrong and how to correct it ?
Issue the SQL command:
ANALYZE
This will help the query planner understand which indexes are best to use; I
have seen it dramatically improve
hello,
i want to update a column name in a table, but the only way for that is
to redo the table
the table have around 15 000 000 records
so i do like this :
ALTER TABLE PICTURE_HASH_ID RENAME TO PICTURE_HASH_ID_OLD;
DROP INDEX PICTURE_HASH_ID_PIC_IDX;
CREATE TABLE PICTURE_HASH_ID(
HASH_ID
2 matches
Mail list logo