Cluster, Non cluster and Full Text Indexing Techniques for Efficient Database

Data warehouse is the central management system having pool of datasets. The traditional data warehouse was designed in such a manner that it can efficiently manage transactional data which is highly dominated by numerical information where as in some data warehouse textual and non t The dataset which contains text data is accessed over the network on the daily basis and performance issue arises. The objective of this paper is to propose an indexing technique based on time complexity and index s complexity for data warehouse used in applications. The performance evaluation of three data warehouse queries is focused in this paper by comparing techniques used mostly with FULL T