Home › Forums › Other › How to setup a database table? › Re: How to setup a database table?
June 30, 2013 at 11:35 pm
#141097
__Participant
`SELECT title,url` can’t use a PK index created on `url,title`. It will have to actually access and read the rows in the table itself (which is much slower than just reading the index).
`SELECT url,title …` (or even just `SELECT url …` (but not `SELECT title …`)) can get everything it needs from that index and bypass reading the table entirely.
