Question: Won't it make the query faster?

Asked By
dylan.dpc
Asked At
2017-09-06 06:51:41

Found 15 possible answers.

User Answered At Possible Answer
ajcastro 2017-09-06 06:57:46 all columns are indexed.. and it is blazing fast in the first 0%-25% of the execution... thanks @guuske for the help!
guuske 2017-09-06 07:02:33 only reading, @dylan.dpc , not insert / update
dylan.dpc 2017-09-06 07:02:49 True In fact the more indexes you have the slower the insert is :smile: I don't know what's his query like
guuske 2017-09-06 07:03:20 copied above at 04:31AM
dylan.dpc 2017-09-06 07:03:38 I don't know your timezone :stuck_out_tongue: Ah saw his message
guuske 2017-09-06 07:04:25 I(rish)ST not I(ndian)ST
dylan.dpc 2017-09-06 07:05:36 Haha I don't think you people call it IST
guuske 2017-09-06 07:06:11 no we don't it's really BST, but heyho
dylan.dpc 2017-09-06 07:06:25 :+1 :: skin-tone-2: Probably you need some sleep :smile: :joy: :joy:
guuske 2017-09-06 07:06:58 nah, it's 08:00... only been up for 2 hours... :smile:
dylan.dpc 2017-09-06 07:07:03 Ohk
jordyvd 2017-09-06 08:27:36
 while (date <= end_date)
    commit transaction;
might want to start transaction before you loop. date++; insert data into target_table data = read from src_table; begin transaction;
guuske 2017-09-06 08:39:34 Not really, @jordyvd
dylan.dpc 2017-09-06 08:39:53 Ye Jordy is right Lot Though roll back would be a lit
guuske 2017-09-06 08:40:30 categorically, one should say "It depends"

Related Questions