Loading

A table without index in SQL

Manish Sharma

14y1.4k

Hi Friends

I want to know that for what purpose a table can be used without Cluster nor Non-cluster Index ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

suppose you have reuirment like you can only insert record with in table, no select no update no delete at this time you can use table without Cluster nor Non-cluster Index.

hope this will help you.
Akkiraju Ivaturi14y ago
A table without indexes is not useful in applications where retrieval of data is prime importance. If you just want to dump some data you can go ahead with table without indexes. But, a table with index if it takes 5 seconds for a select statement, it is going to take 5-10 minutes without indexes. But, it is still possible.