chetana bhargav <bhargav_chetana-/[EMAIL PROTECTED]> wrote:
I just want to know, if we create an index on any table, how the index is stored, is it stored in a seperate file or as part of the current table only in the same file.
With SQLite, the whole database is stored in a single file - all its tables, indices, triggers, views and so on.
Igor Tandetnik