Index and join issue
-
I have two problem, 1. how many types of indexes in sql server. also if we delete the table having one cluster indexes and 2 non cluster indexes.then what happen.can any one tell me about that.how can we delete the table and if table is deleted then what is happening about cluster and non clustered indexes.is it deleted automatically. 2. i need to left outer join with where clause with 2nd table.what is the output of the query. it will return all rows of 1st table or it will return only selected rows
-
I have two problem, 1. how many types of indexes in sql server. also if we delete the table having one cluster indexes and 2 non cluster indexes.then what happen.can any one tell me about that.how can we delete the table and if table is deleted then what is happening about cluster and non clustered indexes.is it deleted automatically. 2. i need to left outer join with where clause with 2nd table.what is the output of the query. it will return all rows of 1st table or it will return only selected rows
Ajeet mittal wrote:
1. how many types of indexes in sql server. also if we delete the table having one cluster indexes and 2 non cluster indexes.then what happen.can any one tell me about that.how can we delete the table and if table is deleted then what is happening about cluster and non clustered indexes.is it deleted automatically.
Yes
Ajeet mittal wrote:
2. i need to left outer join with where clause with 2nd table.what is the output of the query. it will return all rows of 1st table or it will return only selected rows
What do you think? Have you tried it? If so, what happens?
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush