What is non clustered index and what is B-tree structre in index.

Question

what is non clustered index. can i make non clustered index using 2 table of 4 columns. For example 2 table is first is Customer and second is Employee table. 4 colums from both table like cust_name, cust_id, emp_id, emp_name. can i make non clustered index using these columns.

Answer 1

Hi Monika,


Pragma automatic_index command is by deafult true in Sqlite.

so when you  used Pragma automatic_index=true, its mean indexing will be continue


to stop default indexing use 

sqlite> Pragma automatic_index=false.