2.8.4

Database feature : INDEX field.Database Index Field

In order to optimise your queries, you can set some important fields as index. It means that they will be stored in an index table for searching faster on it.
For instance, if you store a list of products codes, define the code field as INDEX it will be faster to search on it.
An index field becomes automatically unique

Really great Joomla tool Cook is a great piece of kit for creating Joomla components. It uses a drag-n-drop interface to build tables and fully featured pages. You can test your component in a sandbox before downloading it packaged up ready to install. The developer is responsive on the support forum.
Twev (JED)
          

Get Started