If you have where condition on non indexed column then we go for full table scan.
Can you confirm this? Thanks. Rajeshbabu. ________________________________ This e-mail and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! ________________________________ From: xuxc1120 [[email protected]] Sent: Thursday, October 30, 2014 1:20 PM To: user Subject: how to use index for this query situation? table: each col with local index(col1......coln), when i select data such as : select col1,col2 from table where col1="test", the index works, but if there are 2 or more conditions after "where" clause,the query will full scan the table; is there any way to use index for such query? thanks. xuxc
