[sqlite] sqlite-3.8.5: is auto index created multiple times for a single statement?

[Nissl Reinhard]

Hi,

while preparing this statement


create table gpBestellvorschlagInfo as
select GanttPlanID
, BestellterminRaw
, case when not (
     select max(HinweisCodiert)
     from Bestellvorschläge
     where ArtikelOID = o.ArtikelOID
         and HinweisCodiert <> 1
) is null then
(
     select group_concat(Hinweis, x'0d0a')
     from (
         select distinct Hinweis
         from Bestellvorschläge
         where ArtikelOID = o.ArtikelOID
         order by HinweisCodiert desc
     )
)
else
     null
end as Hinweis
from BestellVorschläge o
where not GanttPlanID is null


I get this log message twice:

automatic index on Bestellvorschläge(ArtikelOID)

I hope that the index is created only once when executing the prepared 
statement. But does the query optimizer consider the costs for creating the 
index twice?

Bye.
--
Reinhard Nißl, TB3, -198

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users