Thread: to create indexing!!!
View Single Post
  #1  
Old 09-18-2006, 07:27 AM
paoli paoli is offline
Junior Member
  
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
paoli is on a distinguished road
Default to create indexing!!!
hi, i need to create additional indexing for a table.
Query:
Alter TABLE `banner` ADD INDEX `test_idx` ( `camp_id`,`is_unique`,`event_type`,`stamp` )
currently the record num:13573730
size: 1.2 GB
is there anyway to create indexing for this large table? plz help anyone!
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - to create indexing!!!
Thread: to create indexing!!!
View Single Post
  #1  
Old 09-18-2006, 07:27 AM
paoli paoli is offline
Junior Member
  
Join Date: Sep 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
paoli is on a distinguished road
Default to create indexing!!!
hi, i need to create additional indexing for a table.
Query:
Alter TABLE `banner` ADD INDEX `test_idx` ( `camp_id`,`is_unique`,`event_type`,`stamp` )
currently the record num:13573730
size: 1.2 GB
is there anyway to create indexing for this large table? plz help anyone!
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote