What is the fastest way of accessing a row in a table?

Question

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted?

Answer 1

The fastest way to access the row is by using rowid (or) By making index of that row.