| Author |
Topic |
|
a_r_satish
Yak Posting Veteran
84 Posts |
 Posted - 2006-03-10 : 05:32:22
|
| Hi,For my application i am using a table with huge number of records. So i am going for the Indexing Option.But the records size are too large... i jus wanna know whether is there any option to create index based on certain coditions???For Ex: Checking for <Cl value> > 2000 alone for an index???Thanks is advance.Regards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-10 : 05:54:01
|
no.there's no point in that.Go with the flow & have fun! Else fight the flow  |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-10 : 10:27:24
|
| The record size is too large to index? That doesn't make any sense. |
|
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-03-13 : 02:30:34
|
| by Record size, i meant the number of records is too large.Thats the reason i asked that questionRegards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-13 : 02:36:20
|
| do you mean the width of the column is too wide and you cannot put an index on it? Or are you saying you have too many rows in the table you want to add an index to?How about you post DDL for your table, maybe some test data the is representative of the type of stuff you are storing as well as some sample queries. We can help you with what indexes would be appropriate if you give us the proper information.-ec |
|
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-03-13 : 03:19:37
|
| i meant the number of records in my table is huge.i didnt say about the width of the column which i am indexing.Regards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-03-13 : 03:29:23
|
quote:
Originally posted by a_r_satish
i meant the number of records in my table is huge.i didnt say about the width of the column which i am indexing.
there is no limit onthe number of rows that can be in an index. There is no such thing as a conditional index, where only certain rows meeting a specific criteria are indexed. That does not exist.There are some limitations on how wide a column can be and still be included in an index. There are some limitations on the datatypes that can be included in an index as well.Please post some DDL for your table, some sample data and the queries that you typically run. We can then help you with your indexing. Without that information we cannot help you. -ec |
|
|
|
a_r_satish
Yak Posting Veteran
84 Posts |
Posted - 2006-03-13 : 04:36:26
|
| Thanks for the information.Ya i know that some datatypes cannot be indexed and some other constraints on indexing too. due to some official reasons i am unable to send u the details. Really sorry. If any problems in future then surely post my doubts. Thanks for your time and consideration.Regards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-03-13 : 07:33:15
|
| >>"going for the indexing option" my guess: he's got a huge table with no indexes, is trying to create one in EM, but it takes too long to build and/or he is running out of disk space.so, he just wants to index "some" of the rows. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-03-13 : 09:50:51
|
quote:
Originally posted by jsmith8858so, he just wants to index "some" of the rows.
Yeah, and if only people actually thought for even a moment about what they were asking, they'd realise how ridiculous a concept it is.If you've allowed the table to get too big, you'll have to take the hit and either index it completely, or extract the data to partition it, or both.-------Moo. :) |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-13 : 11:21:52
|
| Define "huge". I'm curious as to how many records you are talking about. And I hope this is not just an issue of being too cheap to buy additional storage drives. |
|
|
|
|
Conditional Indexing