Destroying Indexes.

[David King]

I have a strong Oracle background but I am new to the SQLServer world so please forgive me for my ignorance.

In Oracle you can "destroy" an index if you use ceartian functions on that indexed column in the join criteria. Is this the case with SQLServer, if so can someone supply me a list of index destroyers?

Thanks for you help in advance!

Regards,
David

[SATYA]

select col1
from tab1(index_id 0)
where ....

index_id 0 forces table scan


------------
David King at 6/18/99 2:18:24 PM

I have a strong Oracle background but I am new to the SQLServer world so please forgive me for my ignorance.

In Oracle you can "destroy" an index if you use ceartian functions on that indexed column in the join criteria. Is this the case with SQLServer, if so can someone supply me a list of index destroyers?

Thanks for you help in advance!

Regards,
David