c# - Search in colums of view in database -

i have view i've created joining several tables records can changed content of columns of view can changed. columns of view contain data address,random numbers,date,some random string etc.

i'm accepting search text user , returns rows if of column contain text entered user.

my view have millions of records normal query won't work(takes long time) ? efficient way search view changes tables changed ?

i'm using oracle database,c#,entityframework.

for better performance should add index in original table .. these indexes automatically refreshed rdbms engine on each change .. impossible obtain wrong data index value .. index value , table data contain same values..

you don't need reindex every time ... (monthly) can updated related statistcs ..

so index can change performance in better lot .. , view

the view in create on top of original table on fly , not stored copy of original tables .. indexes view render more fastly expected result ..

the indexes indexes when designed, serve important purposes in database server:

they let rdbms

• find groups of adjacent rows instead of single rows.
• avoid sorting reading rows in desired order.
• let server satisfy (sometimes) entire queries index alone, avoiding (when possible) need access table @ all.

from mysql https://dev.mysql.com/doc/refman/5.5/en/mysql-indexes.html

https://dev.mysql.com/doc/refman/5.5/en/column-indexes.html https://dev.mysql.com/doc/refman/5.5/en/multiple-column-indexes.html

http://code.tutsplus.com/tutorials/top-20-mysql-best-practices--net-7855

http://use-the-index-luke.com