Kev txhim kho tau raug ua rau tus neeg npaj nug. Txhim kho kev ua tau zoo ntawm "SELECT min(x) LOS NTAWM t Qhov twg y IN (?,?,?)" cov lus nug thaum qhov ntsuas t(x,y) nyob. Ua kom pom qhov muaj peev xwm ntawm kev siv tag nrho-index-scan query plan rau cov lus nug nrog "INDEXED BY" qhia.
lub hom WAL (Sau-Ua ntej Logging) Yog tias kev sau ntawv tsis ua haujlwm, ua rau cov ntaub ntawv ua txhaum cai hauv cov ntaub ntawv shm, kev hloov pauv tom ntej tam sim no tuaj yeem rov qab ua qhov ncaj ncees ntawm cov ntaub ntawv shm yog tias muaj cov ntawv nyeem nquag, tsis txhob cuam tshuam SQLITE_PROTOCOL yuam kev.