Return to Answer

deleted 3 characters in body

edited Jun 27, 2017 at 11:34

31.8k
13
103
152

According to your question you have a table with field A and B. If you your query is:

 According to your question you have a table with field A and B. If you your query is: SELECT * FROM [YOUR TBL] WHERE A='XXXX' Optimizer will chose the Composite index to avoid Extract random access! SELECT * FROM [YOUR TBL] WHERE A='XXXX'

Optimizer will chose the Composite index to avoid Extract random access!

 According to your question you have a table with field A and B. If you your query is: SELECT * FROM [YOUR TBL] WHERE A='XXXX' Optimizer will chose the Composite index to avoid Extract random access!

According to your question you have a table with field A and B. If you your query is:

SELECT * FROM [YOUR TBL] WHERE A='XXXX'

Optimizer will chose the Composite index to avoid Extract random access!

Source Link

answered Jun 27, 2017 at 10:30

BongSey

 According to your question you have a table with field A and B. If you your query is: SELECT * FROM [YOUR TBL] WHERE A='XXXX' Optimizer will chose the Composite index to avoid Extract random access!