Why can't use INDEX while querying?

2002-03-04 Thread Buding Chen
Hi, all: I create a table as following: CREATE TABLE appsvr_trarte ( rte_id bigint(38) NOT NULL auto_increment, strConfName varchar(70) NOT NULL default '', lFromTime int(16) unsigned NOT NULL default '0', lToTime int(16) unsigned NOT NULL default '0', iSvrType tinyint(2)

Why can't use INDEX while querying?

2002-03-04 Thread Egor Egorov
Buding, Monday, March 04, 2002, 3:37:08 PM, you wrote: BC Hi, all: BC I create a table as following: BC CREATE TABLE appsvr_trarte ( BC rte_id bigint(38) NOT NULL auto_increment, BC strConfName varchar(70) NOT NULL default '', BC lFromTime int(16) unsigned NOT NULL default '0', BC

another problem and Re: Why can't use INDEX while querying?

2002-03-04 Thread Buding Chen
Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 04, 2002 11:56 PM Subject: Why can't use INDEX while querying? Buding, Monday, March 04, 2002, 3:37:08 PM, you wrote: BC Hi, all: BC I create a table as following: BC CREATE TABLE appsvr_trarte ( BC rte_id bigint(38