Tag: databases
Questions Related to databases
There are 10 tables with similar structure but mutually exclusive records. A query needs to fetch some records from each of these tables. Which of the following is the best approach to do this?
We can use group by clause with:
Bitmap index is suitable for the tables having huge and repeatative(duplicates) data.
SPLIT function is available in SQL server 2005?
DDL means?