OraFAQ Forum: SQL & PL/SQL » How to find cardinality of a table in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » How to find cardinality of a table in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find cardinality of a table in oracle [message #621890]

Tue, 19 August 2014 08:13

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Guys,

We know that if cardinality low to medium then used bitmap index in oracle while cardinality is high then we used binary index, Please let me know here how to know cardinality of table means cardinality is low or high.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621891 is a reply to message #621890]

Tue, 19 August 2014 08:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is GOOGLE broken for you?

http://en.wikipedia.org/wiki/Cardinality_(SQL_statements)

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621892 is a reply to message #621890]

Tue, 19 August 2014 08:26

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

We know that if cardinality low to medium then used bitmap index in oracle while cardinality is high then we used binary index

This statement is false.

[Updated on: Tue, 19 August 2014 08:27]

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621893 is a reply to message #621892]

Tue, 19 August 2014 08:33

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

We could not understand, here BlackSwan has given mathmatical example but i need example any table.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621894 is a reply to message #621893]

Tue, 19 August 2014 08:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db121/search?remark=quick_search&word=cardinality

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621896 is a reply to message #621890]

Tue, 19 August 2014 09:02

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Search the forum for indexes, Kevin and Ross have so many times posted useful information. For understanding about Binary-tree indexes, there is a good write up by Ross, visit his blog in OraFAQ. Recently he also posted a link in community hangout about his video on understanding indexes. You would like the content and his accent Wink

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621921 is a reply to message #621896]

Tue, 19 August 2014 13:14

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Actually I need to use index in my table, In my table column has 10 million data then what type index we have used here.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621922 is a reply to message #621921]

Tue, 19 August 2014 13:17

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The appropriate one, if any.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621923 is a reply to message #621921]

Tue, 19 August 2014 13:17

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

aaditya321 wrote on Tue, 19 August 2014 14:14

Actually I need to use index in my table, In my table column has 10 million data then what type index we have used here.

Not enough information. Did you understand what cardinality is yet?

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621924 is a reply to message #621896]

Tue, 19 August 2014 13:17

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Lalit Kumar B wrote on Tue, 19 August 2014 09:02

Search the forum for indexes, Kevin and Ross have so many times posted useful information. For understanding about Binary-tree indexes, there is a good write up by Ross, visit his blog in OraFAQ. Recently he also posted a link in community hangout about his video on understanding indexes. You would like the content and his accent

Lalit please share link to assist me where you have seen them post.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621926 is a reply to message #621924]

Tue, 19 August 2014 13:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What prevents you from testing one at a time the different index possibilities by producing and examining the EXPLAIN PLANS to actually see for yourself which produces the most desirable results?

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621927 is a reply to message #621924]

Tue, 19 August 2014 13:50

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

aaditya321 wrote on Tue, 19 August 2014 20:17

Lalit Kumar B wrote on Tue, 19 August 2014 09:02
Search the forum for indexes, Kevin and Ross have so many times posted useful information. For understanding about Binary-tree indexes, there is a good write up by Ross, visit his blog in OraFAQ. Recently he also posted a link in community hangout about his video on understanding indexes. You would like the content and his accent

Lalit please share link to assist me where you have seen them post.

Unable to search in the site?

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621930 is a reply to message #621927]

Tue, 19 August 2014 14:10

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

I couldn't get exact site link where get our answers.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621931 is a reply to message #621930]

Tue, 19 August 2014 14:19

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you can't how could we?
We have the same tool than you to search for.

[Updated on: Tue, 19 August 2014 14:19]

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621983 is a reply to message #621931]

Wed, 20 August 2014 05:11

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

No one sharing exact answer here that find to cardinality. Suppose I have 50 columns in my table then how to calculate cardinality.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #621986 is a reply to message #621983]

Wed, 20 August 2014 05:19

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

One prefers you learn to find it by yourself with his/her help rather than spoon-feeding you.

What is the cardinality for you?

[Updated on: Wed, 20 August 2014 05:21]

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #622005 is a reply to message #621983]

Wed, 20 August 2014 07:18

knw15pwr
Messages: 134
Registered: March 2010

Senior Member

I suppose you did not reach the proper link that Blackswan posted.
This is the link :
http://en.wikipedia.org/wiki/Cardinality_(SQL_statements)
(note the "_(SQL_statements)" at the end of the link.)
Hope this helps.

Report message to a moderator

Re: How to find cardinality of a table in oracle [message #622009 is a reply to message #622005]

Wed, 20 August 2014 07:26

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Thank you so much to all guys.

Report message to a moderator

Previous Topic:	Retrieve one transaction which has max Net Sales in that day for 1 year and display by date
Next Topic:	Table dependency for Audit tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 12:09:15 CDT 2024