M
M
M__jane2015-11-24 12:06:44
Database
M__jane, 2015-11-24 12:06:44

Is there a difference (in terms of the speed of operations with a table) by what to build an index, by varchar or int?

Probably for different bases on a miscellaneous, oracle, mssql interests.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexey Lebedev, 2015-11-24
@swanrnd

The difference is not fundamental, but it all depends on the size of the index.
varchar(1) is better than int which is better than varchar(50)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question