doubt about indexes

2007-05-29 Thread Ricardo Conrado Serafim
Hi Group! I've a doubt about indexes and I hope that you can help me. If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and I do a query where the clause where use just col_1, col_2, col_4 and col_5. This query will use the index at least with the col_1 and col_2

Re: doubt about indexes

2007-05-29 Thread Baron Schwartz
Hi Ricardo, Ricardo Conrado Serafim wrote: Hi Group! I've a doubt about indexes and I hope that you can help me. If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and I do a query where the clause where use just col_1, col_2, col_4 and col_5. This query will use