At 12:13 PM 1/13/2007, Nurullah Akkaya wrote:
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 U
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
