Reputation:

mysql view index

Do you know index can be added to MySQL view?

Thanks

Upvotes: 7

Answers (3)

Reputation:

However, you can use some tricks. Add custom_id field to view and put value of "hash" of another unique field in same row :D

In my case i combine category id and article id

Upvotes: 0

Reputation: 105918

Nope.

For more information about indexes and MySQL view performance, read this question.

Upvotes: 0

Reputation: 64409

Sadly, you can't. You can index the tables the view is based on.

Upvotes: 6