Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shubhada
Posting Yak Master
117 Posts |
 Posted - 2006-04-10 : 09:36:08
|
| Hi, I have one query related to execution of index.Suppose I have one table as followempno empname sal1 abc 100002 xyz 200003 por 30000empno is primary key and have index on this primary key.My query is that suppose by mistake index has been deleted then how data can be access? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-10 : 09:38:46
|
Can't you can re-create the index ?Anyway, you don't need index to access the data. For example , just select * from yourtable where empno = 2
KH |
 |
|
|
shubhada
Posting Yak Master
117 Posts |
Posted - 2006-04-10 : 09:41:54
|
| plz explain me the difference of with index and without index on table.we use index to access the data from table (performance point of view) .i am right or not...shubhada |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-10 : 10:08:11
|
| Read about index in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Query related to Index