indexing problem.. millions of records..

[sarath_777]

hi,
i have a huge table which has a index
defined on 3 columns BookName, Articles and PageNo.
But, i can't use the index to search the big table as i have data for only BookName in another small table.
Is there any way i could make use of the index ?
Since, table is too big, i can't search on
the name alone .. If i do the join, will it
use the index ?
thanks
sarath

[Clunietp]

The index will be used in the join if it is the field you are joining your tables on.

[sarath_777]

thanks..