this is my table:

CREATE TABLE IF NOT EXISTS `artikulli` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `autori` varchar(100) CHARACTER SET utf8 NOT NULL,
  `perkthyesi` varchar(100) CHARACTER SET utf8 NOT NULL,
  `category` varchar(100) CHARACTER SET utf8 NOT NULL,
  `titulli` varchar(350) CHARACTER SET latin1 NOT NULL,
  `nen_titulli` varchar(400) CHARACTER SET utf8 NOT NULL,
  `url_alias` varchar(400) COLLATE utf8_unicode_ci NOT NULL,
  `burimi` varchar(200) CHARACTER SET utf8 NOT NULL,
  `teksti` text CHARACTER SET latin1 NOT NULL,
  `intro` text COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `date` int(11) NOT NULL,
  `views` int(10) NOT NULL,
  `is_perhershme` int(10) NOT NULL,
  `etiketat` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `featured` tinyint(10) NOT NULL,
  `ft_order` int(10) NOT NULL,
  `show_picture` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=51 ;

id is the unique Id of each article, i get articles with $_GET;

so is this the right field to create index?

id is your primary key so it is already indexed

mysql> show indexes from artikulli;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.