Tag Info

New answers tagged

0

Running EXPLAIN QUERY PLAN on your query gives this: 0|0|0|SCAN TABLE LEGS AS l 0|0|0|EXECUTE LIST SUBQUERY 1 1|0|5|SEARCH TABLE TRAVELDAYS AS d USING AUTOMATIC PARTIAL COVERING INDEX (Day=? AND Value=?) 1|1|4|SEARCH TABLE TRAINS AS t USING AUTOMATIC COVERING INDEX (TrainDaysUID=?) 1|2|0|SEARCH TABLE LEGS AS l USING AUTOMATIC COVERING INDEX (TrainUID=?) ...


0

When the order of pages in the file has no relation to the order of pages on the disk, reordering the file does not make sense.


0

They just properly normalize their database so that it is possible to store an arbitrary number of numbers; something like this: CREATE TABLE Contacts ( ContactID INTEGER PRIMARY KEY, Name TEXT ); CREATE TABLE PhoneNumbers ( ContactID INTEGER REFERENCES Contacts(ContactID), Number TEXT );


1

Aftee searching the Ideone FAQ, it seems that it uses Sqlite3 for the SQL language. Sqlite needs PRAGMA foreign_keys = ON; to enable foreign keys checks. As they say in their docs: SQLite Foreign Key Support : Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA ...



Top 50 recent answers are included