The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Other How to setup a database table? Re: How to setup a database table?


`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.