Hi,
THrough a reporting tool I have joined
two large tables and there is no index
in that tables.
Half way through the query we found there is no
index in that tables and we created with out cancelling
the queries.
After the index creation it seems the query
running fast.. and I think it started using the index.
is it correct?
Please suggest.
Thanks and regards
Giri