>It's not the first field in the index, so I don't think it >will use it
>for searching on "WHERE field5 = 'xxx' ".
>Try adding an index on field5 only
> CREATE UNIQUE INDEX main_indexf5 ON main (field5);
>I don't see any problem.
Thanks Jay.
You are right.
The query
> >> I have to search for field5 in some DB files (30 or more >>for a total of
> >> 50 GB of space and 150 M of records ).
>
> >> select * from main where field5= "AABBCCDD";
>
>
>
> > Did you put an index on field5?
>
> Yes I use:
>
> CREATE UNIQUE INDEX main_index ON main
>> I have to search for field5 in some DB files (30 or more >>for a total of 50
>> GB of space and 150 M of records ).
>> select * from main where field5= "AABBCCDD";
> Did you put an index on field5?
Yes I use:
CREATE UNIQUE INDEX main_index ON main (field2,field5,field7);
Is a
>
> I have to search for field5 in some DB files (30 or more for a total of 50 GB
> of space and 150 M of records ).
>
> The DBs have the same structure.
>
> I want to find the string (if exist) in all DBs.
>
> The query is like this:
>
>
>
> select * from main where field5= "AABBCCDD";
Hello,
I have this Database:
CREATE TABLE other( field1 VARCHAR(15), field2 VARCHAR(2), field3 VARCHAR(255),
field4 VARCHAR(255));
CREATE TABLE main ( field1 VARCHAR(15), field5 VARCHAR(8), field2 VARCHAR(2),
field6 VARCHAR(2), INS_82 VARCHAR(2), field7 VARCHAR(255));
CREATE TABLE
5 matches
Mail list logo