if we create dynamic application where on a click , on a text box value we need to search related content from database, and my database is huge,
1-can anybody tell me about those areas where i need to focus for fast searching... which concept i should use for this,
2- for respect of fast sarching which area are responsible like- how u create table, how u query and all that..
3- fast searching is depend on what?
...........................just help me and only give me guidline with help of that i can learn good concept of database and implement it to make efficient database..

indexing

how you create indexes

availability of appropriate indexes