answersLogoWhite

0

What is a composite index?

Updated: 12/19/2022
User Avatar

Wiki User

14y ago

Best Answer

You can create an index for a table to improve the performance of queries issued against the corresponding table. You can also create an index for a cluster. You can create a compositeindex on multiple columns up to a maximum of 32 columns. A composite index key cannot exceed roughly one-half (minus some overhead) of the available space in the data block.

Use the SQL command CREATE INDEX to create an index. CREATE INDEX emp_ename ON emp_tab(ename);

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is a composite index?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are some of the most popular stock market indexes?

American Stock Exchange (AMEX) composite index Dow Jones Industrial Average (DJIA) index NASDAQ composite index NASDAQ 100 index New York Stock Exchange (NYSE) composite index Russell 3000 value index Standard and Poor's (S and P) 500 index


What is the symbol for the NYSE composite index?

$NYA


What is the symbol for Fidelity Nasdaq Composite Index Tracking Stock in NASDAQ?

The symbol for Fidelity Nasdaq Composite Index Tracking Stock in NASDAQ is: ONEQ.


What is the most prominent composite stock index in the US?

NYSE Composite Inbox


Which of these describes a composite stock index?

Whole market (A+)


What one of these describes a composite stock index?

One of these what.........


How many stocks in the NASDAQ composite index?

100


How many stocks in NASDAQ composite index?

100


What is the market cap for Fidelity Nasdaq Composite Index Tracking Stock ONEQ?

As of July 2014, the market cap for Fidelity Nasdaq Composite Index Tracking Stock (ONEQ) is $367,878,000.00.


What is the all-time high of tsx composite 60 index?

14715


What is the all time high of tsx composite 60 index?

14715


What is symbol for shanghai stock exhange composite index?

SSE Composite IndexAs of April 5 2010 At 3:08 am estThis is subject to change (Shanghai: 000001.SS) Index Value:3,157.96Trade Time:Apr 2Change:10.54 (0.33%)Prev Close:3,147.416Open:3,154.77Day's Range:3,141.87 - 3,159.60