hi,
i need some help to see if i understood the point about indexing.
if i have 2 tables. each table has 2 columns. and now i want to join those
tables through one column in each table:
example
T1
C1 C2
|
+--+
|
T2 |
C1 C2
let say the columns in question are C1(t1) and C2(t2)
first question:
can i create index X1 in both columns C1(t1) and C2(t2) ?
second question
if the answer to first question is yes, then if i index the C1(t1) with
index X1 and C2(t2) with L1. will i join my tables slower than if i join
them when they are having the same index. and what is the actual gain when i
create indexes. i know from experience that the stuff go faster , but why ?
(if the answer is too long please direct me to the right literature to study
this further).
thank you
--
View this message in context:
http://www.nabble.com/question-about-indexing-tp22851121p22851121.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
