Contents
- Index
- Previous
- Next
Indices View
At times your may need to know about the schema (or design) of your database tables.
The table Indices view show you the details of the available indexes on your table. This can be very important for programmers who need to ensure that their SQL Queries will perform well. Selecting and sorting by indexed columns result in better performance, so even the novice can use this information to decide how best to sort.
In the above sample we can see that the Company column is indexed, thus a sort on company would be much faster than a sort on address1.