In the last episode (Jun 08), Ying Lu said:
> By the way, I am using 4.0.18-log on i686.linux2.6.10.
> >I did the following two explain select ... According to whether I put
> >the single quotation mark or not, I will get totally different results:
> >
> >1. Without single quotation mark:
> >
> >e
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_test)
WHERE *T1.STUDID = 099 AND T1.Prog_link = *;
By the way, I am using 4.0.18-log on i686.linux2.6.10.
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_t