0

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?

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by pty
1

id is your primary key so it is already indexed

mysql> show indexes from artikulli;

Edited by pty: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.