i have a table with essentaily random data in it.... there is no data field that represents what would be sequential adding of data to the table.
it currently does not have a identity field. (the PK is a guid generated by newid() )
i have read that "heap" table index (no clustered index) produces table scans in the execution plan (which it does)
would it benifit me to add an identity field to the table and create a clustered index on that field?