Re: Index and Order By

BTW, I have force to use index key by using USE INDEX (bysource) for example, in the query, but it didn't look good to me... -- Sent from my BlackBerry. Ignore the typos unless they're funny.

Index and Order By

I am looking for help and suggestion. Mysql Ver 12.18 Distrib 4.0.12, for pc-linux (i686) The table structure: mysql> desc article; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-

Reading large(600k-1000k) number of records.

i have the following table in my database i am trying select postings based on wordId whole table has around 200 million records. DROP TABLE IF EXISTS `postingList`; CREATE TABLE `postingList` ( `wordId` MEDIUMINT UNSIGNED NOT NULL, `docId` INT UNSIGNED NOT NULL, `docPosition` smallint UN