|
|
Posted by Gerry Vandermaesen on 04/11/06 16:41
endlesstide@gmail.com wrote:
> How do I have the dynamic number field in this database index
> optimized? Is that some kind of process that regularly runs to sort
> the database? (Sorry for my ignorance about that). I have about 3
> years of MYSQL under by belt, but that is something new to me.
>
> Dave
You just add an index to the field, it's a onetime operation. Execute
the following SQL:
ALTER TABLE tablename ADD INDEX(columnname)
You can also manage indexes in phpMyAdmin assuming you are using it, in
the table structure view.
Navigation:
[Reply to this message]
|