but, I made the Index on all 3 columns using the Design mode?
Then Unloaded the structure, cut and pasted the Index code.
So maybe you can't Index varchars form the R>?
I think it is due to sun spots and solar activity!
Marc
--------------------------------------------------
From: "Albert Berry" <[email protected]>
Sent: Wednesday, July 14, 2010 3:43 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: How to make this Delete command faster
That's entirely possible. I did not notice that the column was varchar.
Albert
MDRD wrote:
Albert
CREATE INDEX SxTC ON `TravCard` ( `Subjx` ASC )
error
this works
CREATE INDEX SxTC ON `TravCard` ( `sympt1` ASC )
Subjx is a Varchar, Is Indexing Varchar is allowed??
This is my first Varchar column.
Marc
