problem with index

[Guest_imported]

hi friends


1.create index myindex1 table(column1)

2.create index myindex2 table(column2)

i have created two index .

i have to open inden .how i can open index??

thanks & regard
m.a.khaleel

 

[fluteplr]

I sql server you do not open indexes. The server uses them as needed. If what you are trying to do is view the table in a sorted order you will need to do a select with an order by clause.

 

[Guest_imported]

I think u wanna see whether the index you created is being used or not, if that is the case then write a query in sql analyser using those tables (add an order by clause on the column name you indexed) and click 'show execution plan' under query tab, it will show you whether the index created is being used or not.