Without indexing, How to fetch rows fastly from a table ?
Without indexing, How to fetch rows fastly from a table ?
What is the problem if you go for indexing.
another option using constraints (primary key or unique)
Fetching rows fastly can be done using indexes can only be done, if you use indexing for one column there is not at all a problem of accessing the data faster.
if u use more than 1 column on indexing, it might be problem
thanks
if we define a unique or primary key on a column in a table automatically a unique index will be created.No need to define manually.