Hi,
I was just curious about one thing.
First i made three tables and indexed at most two fields of each tables.
Then i inserted almost 100000 records.
the database size was about 1.86 GB.
Then i deleted all the indexes but still the database size remained
the same i.e. 1.86 GB.

I was expecting decrease in database size.

Is this behaviour obvious or i missed something..

Also while querying the indexed table, the query performance is not
that fast.

I did it like this:-

CREATE TABLE WHF(
ID BIGINT NOT NULL,
W1 VARCHAR(200),
F1 BIGINT NOT NULL);
CREATE INDEX WHFIDINDEX ON WORD_HASH_FILE (ID);
CREATE INDEX WHFWFINDEX ON WORD_HASH_FILE (W1,F1);

Then i inserted values...

And i executed following query to fetch record from it..

SELECT ID FROM WHF WHERE WORD IN('a','b',.....) ORDER BY F1 DESC;

It took much time then expected.
I have done same thing in MS SQL SErver previously.
Now the performance degraded with Firebird.

Any Ideas ? Please Help