A table without index in SQL

Question

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

Jignesh Trivedi · Answer

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 Ivaturi · Answer

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.